home *** CD-ROM | disk | FTP | other *** search
/ Night Owl 6 / Night Owl's Shareware - PDSI-006 - Night Owl Corp (1990).iso / 050a / dayo1_18.zip / DAYORPT.DOC
Text File  |  1991-02-04  |  289KB  |  5,037 lines
  1.  
  2.  ╔════════════════════════════════════════════════════════════════════════════╗
  3.  ║                                                                            ║
  4.  ║                                                                            ║
  5.  ║    █▄██████████▒░         █████▒░     ██▒░      ██░    ███████████▒░       ║
  6.  ║    ███▒░       ██▒░      ██▒░ ██▒░    ██▒░      ██░   ██▒░       ██▒░      ║
  7.  ║    ██▒░        ██▒░      █▒░   █▒░     ██▒░    ██░    ██▒░       ██▒░      ║
  8.  ║    ██▒░        ██▒░     ██▒░   ██▒░    ██▒░    ██░    ██▒░       ██▒░      ║
  9.  ║    ██▒░        ██▒░     ██▒░   ██▒░     ██▒░  ██░     ██▒░       ██▒░      ║
  10.  ║    ██▒░        ██▒░     ██▒░   ██▒░     ██▒░  ██░     ██▒░       ██▒░      ║
  11.  ║    ██▒░        ██▒░     ██▒░   ██▒░      ██▒░██░      ██▒░       ██▒░      ║
  12.  ║    ██▒░        ██▒░    ███▀▀▀▀▀███▒░      ████▒░      ██▒░       ██▒░      ║
  13.  ║    ██▒░        ██▒░    ██▒░     ██▒░       ██▒░       ██▒░       ██▒░      ║
  14.  ║    ██▒░        ██▒░    ██▒░     ██▒░       ██▒░       ██▒░       ██▒░      ║
  15.  ║    ███▒░       ██▒░    ██▒░     ██▒░       ██▒░       ██▒░       ██▒░      ║
  16.  ║    █▀██████████▒░      ██▒░     ██▒░       ██▒░        ███████████▒░       ║
  17.  ║       ░░░░░░░░░░░      ░░░       ░░░        ░░░         ░░░░░░░░░░░░       ║
  18.  ║                                                                            ║
  19.  ║                                                                            ║
  20.  ║                                                                            ║
  21.  ║                                                                            ║
  22.  ║ ▄██▄  █▄ ▄█░  ▄█▄   █▄█▄  ███░       █▄█▄  ███░ █▄█▄  ▄█▄  █▄█▄  ███░ ▄██▄ ║
  23.  ║ █░    ██▄██░  █░█░  █░ █░  █░        █░ █░ █░   █░ █░ █░█░ █░ █░  █░  █░   ║
  24.  ║ █░    █░█░█░  █░█░  █▄▄█░  █░        █▄▄█░ ██░  █▄▄█░ █░█░ █▄▄█░  █░  █░   ║
  25.  ║ ▀██▄  █░█░█░  █▄█░  █▀█░   █░        █▀█░  █░   █░    █░█░ █▀█░   █░  ▀██▄ ║
  26.  ║    █░ █░▀ █░ █▀ ▀█░ █░█▄   █░        █░█▄  █░   █░    █░█░ █░█▄   █░     █░║
  27.  ║ ▀██▀  █░  █░ █░  █░ █░ █░  █░        █░ █░ ███░ █░    ▀█▀  █░ █░  █░  ▀██▀ ║
  28.  ║                                                                            ║
  29.  ║                                                                            ║
  30.  ║                                                                            ║
  31.  ║                                                                            ║
  32.  ║                     SMART REPORTS FOR THE DAYO MODULES                     ║
  33.  ║                                                                            ║
  34.  ║                                                                            ║
  35.  ║     Copyright (c) 1990,  TJS LAB, PO Box 585366, Orlando, Florida 32858    ║
  36.  ║                                                                            ║
  37.  ║                                                                            ║
  38.  ║ ▓▓▓▓▓▓                     ███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌               ║
  39.  ║ ▀ ▓▓ ▀ ▓▓▓▓                ▀▀▀▀▀███████████████████████████▌   S           ║
  40.  ║   ▓▓    ▓▓ ▄▓▓▓▄                  ▀████▀▀      ▀████████████    O          ║
  41.  ║   ▓▓    ▓▓ ▓▓                       ▀▀           ███████████     F         ║
  42.  ║   ▓▓ ▓▓ ▓▓ ▀▓▓▓▄       Specializing In            ▐█████████▌     T        ║
  43.  ║      ▀▓▓▓▀    ▓▓          MicroComputer            ██████████ C    W       ║
  44.  ║            ▀▓▓▓▀             & LAN                 █████■████▌ O    A      ║
  45.  ║                                 Applications      ▐███████████  N    R     ║
  46.  ║                               ┌─┐         ┌─┐      ███████████▌  S    E    ║
  47.  ║ ▀▓▓      ▓   ▀▓▄▓▓▓▄         ┌╧─╧┐  ┌─┐  ┌╧─╧┐      ████▀  ▀███   U        ║
  48.  ║  ▓▓     ▓▓▓   ▓▓  ▓▓         └───╜ ┌╧─╧┐ └───╜       ███    ██▌    L    &  ║
  49.  ║  ▓▓    ▄▓ ▓▄  ▓▓▓▓▓           ░█░  └───╜  ░█░         ███▄▄███      T      ║
  50.  ║  ▓▓    ▓▓▓▓▓  ▓▓  ▓▓         █████  ░█░  █████         ▀█████▌       I     ║
  51.  ║  ▓▓▓▓ ▄▓   ▓▄ ▓▀▓▓▓▀               █████                 ▀▀▀█         N    ║
  52.  ║                                                            █           G   ║
  53.  ║ PO BOX 585366, ORLANDO, FLORIDA 32858                 ▄▄▄▄▀                ║
  54.  ║                                                                            ║
  55.  ╚════════════════════════════════════════════════════════════════════════════╝
  56.    DAYO Smart Reports,       TJS LAB
  57.  
  58.  
  59.  
  60.  
  61.       "Try before you buy..."
  62.  
  63.  
  64.  
  65.               ┌─────────┐
  66.         ┌─────┴───┐     │              (tm)
  67.       ──│         │o    │──────────────────
  68.         │   ┌─────┴╨──┐ │  Association of
  69.         │   │         │─┘  Shareware
  70.         └───│    o    │    Professionals
  71.       ──────│    ║    │────────────────────
  72.             └────╨────┘    MEMBER
  73.  
  74.  
  75.  
  76.       This program is produced by a member of the Association of Shareware
  77.   Professionals (ASP).  ASP wants to make sure that the shareware principle
  78.   works for you. If you are unable to resolve a shareware-related problem with
  79.   an ASP member by contacting the member directly, ASP may be able to help.
  80.   The ASP Ombudsman can help you resolve a dispute or problem with an ASP
  81.   member, but does not provide technical support for members' products. Please
  82.   write to the ASP Ombudsman at 545 Grover Road, Muskegon, MI 49442-9427 or
  83.   send a Compuserve message via easyplex to ASP Ombudsman 70007,3536
  84.  
  85.  
  86.  
  87.   ■ SOFTWARE SUPPORT POLICY
  88.  
  89.  
  90.    1.  TJS LAB does not support users of unregistered DAYO products with the
  91.        exception of installation questions.
  92.  
  93.    2.  Support (included with registration) remains in effect for 1 year after
  94.        date of registration or upgrade.
  95.  
  96.    3.  Support is available through the following methods:
  97.  
  98.        - Phone/Voice Mail: (407) 291-3960/6987
  99.  
  100.        - U.S. Mail:  TJS LAB, PO Box 585366, Orlando, FL 32858-5366
  101.  
  102.        - Compuserve Easyplex:  76367,1401
  103.  
  104.    4.  Any errors ("bugs or features') in the program will be corrected and
  105.        the 'fix' sent promptly (via modem if possible).
  106.  
  107.    DAYO Smart Reports,       TJS LAB                                 Page: 1
  108.  
  109.                                                                                
  110.                                                                                
  111.         Table of Contents                                                      
  112.  
  113.                                                                                
  114.         Page                 Subject
  115.         ────                 ───────────────────────────────────────           
  116.          3   ............... INTRODUCTION
  117.          3   ............... COPYRIGHT/LICENSE
  118.          4   ............... DISCLAIMER
  119.          4   ............... REQUIREMENTS
  120.          4   ............... SETUP
  121.          5   ............... PASSWORD/NAME
  122.          6   ............... MAIN MENU
  123.          6   ............... REPORTS/ROUTINES LIST
  124.          7   ...............   SINGLE WAREHOUSE REPORT
  125.          8   ...............   VALUATION EXPANDED REPORT
  126.          10  ...............   REORDER REPORT  -  2, 4, OR 8 WEEKS AVERAGE
  127.          11  ...............   STOCKLEVEL SHORTAGE REPORT
  128.          12  ...............   STOCKLEVEL OVER REPORT
  129.          13  ...............   INVENTORY ASCII TEXT
  130.          14  ...............   LATE PURCHASE ORDER REPORT
  131.          15  ...............   PURCHASE ORDER DUE IN REPORT
  132.          16  ...............   INVENTORY ZERO COST ITEMS REPORT
  133.          17  ...............   INVENTORY ZERO PRICE ITEMS REPORT
  134.          18  ...............   INVENTORY ZERO RETAIL ITEMS REPORT
  135.          19  ...............   NEGATIVE ONHAND REPORT
  136.          20  ...............   MARGIN HISTORY  (AVERAGE MARGIN & COST)
  137.          21  ...............   MARGIN HISTORY  (LAST 12 WEEKS)
  138.          22  ...............   VENDOR LIST
  139.          22  ...............     EXAMPLE OF THE VENDOR LIST
  140.          23  ...............   CUSTOMER LIST
  141.          23  ...............     EXAMPLE OF THE CUSTOMER LIST
  142.          24  ...............   INVENTORY ITEM LIST
  143.          24  ...............     EXAMPLE OF THE INVENTORY ITEM LIST
  144.          25  ...............   CHECKING ACCOUNT LIST
  145.          25  ...............     EXAMPLE OF THE CHECKING ACCOUNT LIST
  146.          26  ...............   CHECK FORMAT LIST
  147.          26  ...............     EXAMPLE OF THE CHECK FORMAT LIST
  148.          27  ...............   EXPENSES LIST
  149.          27  ...............     EXAMPLE OF THE EXPENSES LIST
  150.          28  ...............   WAREHOUSE ADJUSTMENTS REPORT
  151.          28  ...............     EXAMPLE OF THE WAREHOUSE ADJUSTMENTS REPORT
  152.          29  ...............   HP LASER PULL SHEET/REPORT WITH FILTER
  153.          31  ...............   INVENTORY EXPANDED REPORT WITH FILTER
  154.          32  ...............   INVENTORY AVAILABLE REPORT WITH FILTER
  155.          33  ...............   DUPLICATE RECORD/INDEX KEY REPORT/ROUTINE
  156.          34  ...............   GL POSTING PROBLEMS
  157.          34  ...............     EXAMPLE OF GL POSTING PROBLEMS REPORT
  158.          35  ...............   TAX SUMMARIES
  159.          36  ...............   MASTER INVENTORY
  160.          36  ...............     EXAMPLE OF THE MASTER INVENTORY UPDATE REPORT
  161.          37  ...............   NON-TAXABLE SALES
  162.          38  ...............   BIG LABELS
  163.          38  ...............     BIG LABELS CONFIGURATION
  164.    DAYO Smart Reports,       TJS LAB                                 Page: 2
  165.  
  166.  
  167.  
  168.         Table of Contents
  169.  
  170.  
  171.         Page                 Subject
  172.         ────                 ───────────────────────────────────────
  173.          38.1 ..............   CUSTOMER EXPANDED
  174.          38.2 ..............   AP ADJUSTMENTS
  175.          38.2 ..............   BATCH INVENTORY ADJUSTMENTS
  176.          38.3 ..............   AR ADJUSTMENTS
  177.          38.4 ..............   SPECIAL SALES REPORT I
  178.          38.5 ..............   SPECIAL SALES REPORT II
  179.          38.7 ..............   SPECIAL SALES REPORT III
  180.          38.8 ..............   CUSTOMER LIST #2
  181.          38.9 ..............   EXAMPLE OF THE CUSTOMER LIST #2
  182.          38.91..............   INSERT DECIMALS
  183.          38.92..............   WAREHOUSE REORDER
  184.          38.93..............   SERIAL NUMBERS IN
  185.          38.94..............   EXAMPLE OF THE SERIAL NUMBER IN REPORT
  186.          38.94..............   SERIAL NUMBERS OUT
  187.          38.94..............   EXAMPLE OF THE SERIAL NUMBER OUT REPORT
  188.          38.95..............   BAD RECORDS
  189.          38.96..............   RESET ALLOCATED
  190.          38.97..............   RESET BO - BACK ORDER QUANTITY
  191.          38.98..............   SET MULTIPLE PRICE FIELDS IN INVENTORY
  192.          38.99..............   MULTIPLE PRICING PROGRESS GRAPH
  193.          39   ..............   MODIFY SCREEN COLORS
  194.          39   ..............     COLOR CHART
  195.          39.03..............   ITEM TRACKER
  196.          39.06..............   VIEW REPORTS ON SCREEN
  197.          40   ..............     REPORT VIEWING SCREEN
  198.          41   ..............   PRINTER DRIVER (SETUP)
  199.          41   ..............     PRINTER DRIVER OPTIONS
  200.          42   ..............     CHANGE DEFAULT PRINTER
  201.          43   ..............     FULL SCREEN EDIT - F2
  202.          43   ..............     PRINTER DRIVER DATABASE FIELD DEFINITIONS
  203.          44  ............... CONFIGURATION
  204.          44  ...............   CONFIGURATION LISTING
  205.          45  ...............   COMPANY NAME, ADDRESS & TELEPHONE
  206.          45  ...............   INVENTORY LOCATION/DIRECTORY
  207.          45  ...............   POINT OF SALE (POS) DATABASES LOCATION/DIRECTORY
  208.          46  ...............   CUSTOMER DATABASE LOCATION/DIRECTORY
  209.          46  ...............   ACCOUNTS PAYABLE DATABASES LOCATION/DIRECTORY
  210.          46  ...............   QUOTES DATABASE LOCATION/DIRECTORY
  211.          47  ...............   BACKORDERS DATABASE LOCATION/DIRECTORY
  212.          47  ...............   PRICE BOOK DATABASE LOCATION/DIRECTORY
  213.          47  ...............   REPORT PRINTER TYPE
  214.          47  ...............   REPORT PRINTER PORT
  215.          48  ...............   COLOR MONITOR
  216.          48  ...............   COLOR INTENSITY
  217.          49  ............... MISCELLANEOUS ROUTINES
  218.          49  ...............   MISC ROUTINES MENU
  219.          50  ...............   APPEND FROM
  220.          52  ...............   BROWSE DATABASES
  221.          54  ...............   COPY (.DBF) TO
  222.          56  ...............   CREATE DATABASE
  223.    DAYO Smart Reports,       TJS LAB                                 Page: 2.1
  224.  
  225.  
  226.  
  227.         Table of Contents
  228.  
  229.  
  230.         Page                 Subject
  231.         ────                 ───────────────────────────────────────
  232.          58  ...............   DELETE RECORDS
  233.          59  ...............   ERASE FILE
  234.          59  ...............   EXIT TO DOS
  235.          60  ...............   INDEX A DATABASE
  236.          61  ...............   LIST FIELDS
  237.          64  ...............   MODIFY DATABASE
  238.          65  ...............   PACK DATABASE
  239.          66  ...............   RECALL RECORDS
  240.          66  ...............   RETURN TO MENU
  241.          66  ...............   RUN (DOS COMMAND)
  242.          67  ...............   SIMPLE EDITOR
  243.          68  ...............   SORT DATABASE
  244.          69  ...............   TYPE (PRINT) FILE
  245.          70  ...............   ZAP DATABASE
  246.          72  ............... HELP SCREENS
  247.          73  ...............    EXPANDED HELP
  248.          74  ...............    USER DEFINED & INPUTTED HELP SCREENS/MESSAGES
  249.          75  ...............    VIEW DOCUMENTATION ONSCREEN
  250.          76  ............... DAYO SMART REPORTS MAINTENANCE & QUIRKS
  251.          77  ............... TJS LAB, CUSTOM CODING
  252.    DAYO Smart Reports,     TJS LAB                                   Page: 3
  253.  
  254.                                                                                
  255.                                                                                
  256.  ■ INTRODUCTION
  257.  
  258.       DAYO Smart Reports contains a collection of miscellaneous reports and
  259.   routines that many other software packages leave out. Some of the DAYO Smart
  260.   Reports actually write to your databases (ie: the calculating of the
  261.   STOCKLEVEL field in the database INV.DBF). Smart Reports should be run
  262.   periodically to 'check up on' or comfirm the accuracy of your data.
  263.  
  264.       There are 50+ Reports/Lists/Routines included in Smart Reports:
  265.  
  266.           Single Warehouse                  Expenses List
  267.           Valuation Expanded                Warehouse Adjustments
  268.           ReOrder (2 weeks)                 HP Laser Pull Sheet
  269.           ReOrder (4 weeks)                 Inventory Expanded
  270.           ReOrder (8 weeks)                 Available Inventory
  271.           StockLevel Shortage               Duplicate Records
  272.           StockLevel Over                   View Reports on Screen
  273.           Inventory ASCII Text              Master Inventory Update
  274.           Late PO                           Tax Summaries
  275.           PO - Due In This Week             Non-Taxable Sales
  276.           Inventory Zero Cost               Customer Expanded
  277.           Inventory Zero Price              AP Adjustments
  278.           Inventory Zero Retail             Batch Inventory Adjustments
  279.           Negative Onhand                   AR Adjustments
  280.           Printer Setup                     Special Sales Report #1
  281.           GL Posting Problems               Special Sales Report #2
  282.           Big Labels                        Special Sales Report #3
  283.           Margin (History)                  Customer List #2
  284.           Margin (12 Weeks)                 Insert Decimals
  285.           Vendor List                       Warehouse ReOrder
  286.           Customer List                     Serial Numbers In
  287.           Inventory Item List               Serial Numbers Out
  288.           Checking Account List             Bad Records
  289.           Check Format List                 Modify Screen Colors
  290.                                             Item Tracker *
  291.  
  292.       DAYO Smart Reports is by default a multiuser system.
  293.  
  294.       Other DAYO Products:                                                     
  295.                                                                                
  296.       DAYO Inventory       Inventory Control, Vendors, Purchasing, Receiving   
  297.       DAYO POS             Point of Sales Billing & Invoicing                  
  298.       DAYO Time & Billing  Bill for Time, AR, Inventory
  299.       DAYO Price Books     Special pricing for your customers as well as a wide
  300.                            range of product catalogs/reports                   
  301.       DAYO AR              Accounts Receivable
  302.       DAYO AP              Accounts Payable
  303.       DAYO BO              Back Orders                                         
  304.       DAYO GL              General Ledger
  305.       DAYO Passwords       Password protect your DAYO system
  306.       DAYOX                Network/LAN Index Maintenance Utility               
  307.       & more...
  308.    DAYO Smart Reports,     TJS LAB                                   Page: 4
  309.  
  310.  
  311.  ■ COPYRIGHT/LICENSE
  312.  
  313.       This manual and software is copyrighted with all rights reserved by      
  314.   TJS LAB. No copying of this manual or software is authorized without         
  315.   the prior written consent of TJS LAB. An exception to this rule is the       
  316.   making of backup copies of registered software disks. No RESALE of any part  
  317.   of the source codes is authorized without the prior written consent of       
  318.   TJS LAB. TJS LAB retains all rights to DAYO Smart Reports software,
  319.   documentation, and source codes.
  320.  
  321.       Read the Order Form (last page), for more information on Source Codes... 
  322.                                                                                
  323.       Authorization to distribute the Shareware Version (unregistered) is      
  324.   granted.                                                                     
  325.  
  326.                                                                                
  327.  ■ DISCLAIMER
  328.  
  329.       No warrant is made that this software will work in all environments,     
  330.   or with all resident programs and hardware configurations. TJS LAB has       
  331.   tested this software in many environments and found it to perform as         
  332.   expected, however, this software is licensed "AS IS".                        
  333.                                                                                
  334.        TJS LAB will not be liable for any damage done to your data, hardware   
  335.   and/or software systems as a result of using DAYO Smart Reports.
  336.                                                                                
  337.                                                                                
  338.  ■ REQUIREMENTS    ***
  339.                                                                                
  340.      IBM or Compatible CPU                                                     
  341.      640K memory                                                               
  342.  *   DOS 3.3 or above                                                          
  343.      Hard Disk                                                                 
  344.                                                                                
  345.                                                                                
  346.                                                                                
  347.  ■ SETUP
  348.  
  349.       To setup DAYO Smart Reports, copy the contents of the DAYO Smart Reports
  350.   floppy disk into a directory on your hard disk (ie: \DAYORPT). If this is
  351.   the Shareware Version, you need to UnZip/UnArc the files. When you run
  352.   DAYO Smart Reports for the first time, it will create all the database,
  353.   index, and configuration files it requires for operation. If you are using
  354.   other DAYO modules, be sure to enter the location of these databases into
  355.   the DAYO Smart Reports configuration. Type and enter 'DAYOR' at the DOS
  356.   prompt to run the program (ie:  C:\DAYOR ).
  357.  
  358.   *** Your CONFIG.SYS file must have the buffers set to a minimun of 10, and
  359.   your files must have a minimun setting of 55! Failure to edit the CONFIG.SYS
  360.   file is the #1 cause for DAYO installation problems!  A CONFIG.SYS file is
  361.   created if there is a problem detected, in the directory that this DAYO
  362.   module is being run in. You may copy this file into your root/boot drive.
  363.   Refer to your DOS manual for more information on the CONFIG.SYS file!
  364.    DAYO Smart Reports,     TJS LAB                                   Page: 5
  365.                                                                                
  366.  
  367.  
  368.  
  369.  ■ PASSWORD/NAME
  370.  
  371.       The first prompt you get when you enter DAYO Reports is the one for you
  372.   to enter your name (or password if using DAYO Passwords):
  373.  
  374.  
  375.  
  376.  DAYO Smart Reports Version 2.0,  TJS LAB                ┌───[February 1991]──┐
  377.  Copyright (c) 1989-1991, All Rights Reserved            │S  M  T  W  T  F  S │
  378.  ╔════════════════════════╗   ████▄   ▄█▄  █░  █░ ▄███▄  ├────────────────────┤
  379.  ║                        ║   █░  █░  █░█░ █░  █░ █░  █░ │ 1  2  3  4  5  6  7│
  380.  ║                        ║   █░  █░  █░█░ ▀█░██░ █░  █░ │ 8  9 10 11 12 13 14│
  381.  ║                        ║   █░  █░ █▀▀▀█░ ▀█▀   █░  █░ │15 16 17 18 19 20 21│
  382.  ║                        ║   █░  █░ █░  █░  █░   █░  █░ │22 23 24 25 26 27 28│
  383.  ║   DAYO                 ║   ████▀  █░  █░  █░   ▀███▀  │29 30               │
  384.  ║       Smart            ║                              │                    │
  385.  ║            Reports     ║                              └────────────────────┘
  386.  ║                        ╠══════════════════════════════════════════════════╗
  387.  ║                        ║                                                  ║
  388.  ┌────────────────────────────────────────────────────────────────────────────┐
  389.  │┌──────────────────────────────────────────────────────────────────────────┐│
  390.  ││   Enter Your Name:  George Moonilal                                      ││
  391.  │└──────────────────────────────────────────────────────────────────────────┘│
  392.  └────────────────────────────────────────────────────────────────────────────┘
  393.  ╚════════════════════════╩══════════════════════════════════════════════════╝
  394.     ▄██▄  █▄ ▄█░  ▄█▄   █▄█▄  ███░       █▄█▄  ███░ █▄█▄  ▄█▄  █▄█▄  ███░ ▄██▄
  395.     █░    ██▄██░  █░█░  █░ █░  █░        █░ █░ █░   █░ █░ █░█░ █░ █░  █░  █░
  396.     █░    █░█░█░  █░█░  █▄▄█░  █░        █▄▄█░ ██░  █▄▄█░ █░█░ █▄▄█░  █░  █░
  397.     ▀██▄  █░█░█░  █▄█░  █▀█░   █░        █▀█░  █░   █░    █░█░ █▀█░   █░  ▀██▄
  398.        █░ █░▀ █░ █▀ ▀█░ █░█▄   █░        █░█▄  █░   █░    █░█░ █░█▄   █░     █░
  399.     ▀██▀  █░  █░ █░  █░ █░ █░  █░        █░ █░ ███░ █░    ▀█▀  █░ █░  █░  ▀██▀
  400.  
  401.    DAYO Smart Reports,     TJS LAB                                   Page: 6
  402.  
  403.  
  404.  
  405.  ■ MAIN MENU
  406.  
  407.       After a few moments and possibly a reindex, the main menu will appear
  408.   (the left side of the screen is the actual main menu):
  409.  
  410.  DAYO Smart Reports Version 2.0,  TJS LAB                ┌───[February 1991]──┐
  411.  Copyright (c) 1989-1991, All Rights Reserved            │S  M  T  W  T  F  S │
  412.  ╔════════════════════════╗   ████▄   ▄█▄  █░  █░ ▄███▄  ├────────────────────┤
  413.  ║Configuration           ║   █░  █░  █░█░ █░  █░ █░  █░ │ 1  2  3  4  5  6  7│
  414.  ║Single Warehouse        ║   █░  █░  █░█░ ▀█░██░ █░  █░ │ 8  9 10 11 12 13 14│
  415.  ║Valuation Expanded      ║   █░  █░ █▀▀▀█░ ▀█▀   █░  █░ │15 16 17 18 19 20 21│
  416.  ║ReOrder (2 weeks)       ║   █░  █░ █░  █░  █░   █░  █░ │22 23 24 25 26 27 28│
  417.  ║ReOrder (4 weeks)       ║   ████▀  █░  █░  █░   ▀███▀  │29 30               │
  418.  ║ReOrder (8 weeks)       ║                              │                    │
  419.  ║StockLevel Shortage     ║                              └────────────────────┘
  420.  ║StockLevel Over         ╠═[ Configuration ]═════════════════════════════════╗
  421.  ║Inventory ASCII Text    ║                                                   ║
  422.  ║Late PO                 ║ ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■              ║
  423.  ║PO - Due In This Week   ║ DAYO Reports Configuration Settings.              ║
  424.  ║Inventory Zero Cost     ║ ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■              ║
  425.  ╠════════════════════════╣                                                   ║
  426.  ║  Press  Esc  to Exit   ║                                                   ║
  427.  ╚════════════════════════╩═══════════════════════════════════════════════════╝
  428.     ▄██▄  █▄ ▄█░  ▄█▄   █▄█▄  ███░       █▄█▄  ███░ █▄█▄  ▄█▄  █▄█▄  ███░ ▄██▄
  429.     █░    ██▄██░  █░█░  █░ █░  █░        █░ █░ █░   █░ █░ █░█░ █░ █░  █░  █░
  430.     █░    █░█░█░  █░█░  █▄▄█░  █░        █▄▄█░ ██░  █▄▄█░ █░█░ █▄▄█░  █░  █░
  431.     ▀██▄  █░█░█░  █▄█░  █▀█░   █░        █▀█░  █░   █░    █░█░ █▀█░   █░  ▀██▄
  432.        █░ █░▀ █░ █▀ ▀█░ █░█▄   █░        █░█▄  █░   █░    █░█░ █░█▄   █░     █░
  433.     ▀██▀  █░  █░ █░  █░ █░ █░  █░        █░ █░ ███░ █░    ▀█▀  █░ █░  █░  ▀██▀
  434.  Report 1 of 31
  435.  
  436.       Note that this DAYO Module has a different Main Menu. With the exception
  437.   of the CONFIGURATION and MISC ROUTINES menu options, all other options listed
  438.   on the DAYO Smart Reports menu are reports.
  439.  
  440.  
  441.  
  442.  ■ REPORTS/ROUTINES LIST
  443.  
  444.               Configuration                    Margin (History)
  445.               Single Warehouse                 Margin (12 Weeks)
  446.               Valuation Expanded               Vendor List
  447.               ReOrder (2 weeks)                Customer List
  448.               ReOrder (4 weeks)                Inventory Item List
  449.               ReOrder (8 weeks)                Checking Account List
  450.               StockLevel Shortage              Check Format List
  451.               StockLevel Over                  Expenses List
  452.               Inventory ASCII Text             Warehouse Adjustments
  453.               Late PO                          HP Laser Pull Sheet
  454.               PO - Due In This Week            Inventory Expanded
  455.               Inventory Zero Cost              Available Inventory
  456.               Inventory Zero Price             Reports On Screen
  457.               Inventory Zero Retail            Printer Setup
  458.               Negative Onhand                  Misc Routines
  459.               Duplicate Records                Non-Taxable Sales
  460.               Reset Allocated                  Reset BO
  461.               Set/Reset Prices
  462.    DAYO Smart Reports,     TJS LAB                                   Page: 7
  463.  
  464.  
  465.  
  466.  ■ SINGLE WAREHOUSE REPORT
  467.  
  468.       The Single Warehouse Report prints cost information about each item in a
  469.   specific warehouse (found in the WAREHOUS.DBF). This report also includes the
  470.   valuation of each item (cost * quantity). This report is 'hard coded'; not a
  471.   report form.
  472.  
  473.  
  474.       The following fields/variables are printed:
  475.  
  476.       Item
  477.       VendItem
  478.       Description
  479.       Cost
  480.       Price
  481.       Main Inventory Stock Level
  482.       LOCxxx        (Warehouse Quantity)
  483.       SLLOCxxx      (Stocking Level for this Warehouse Item)
  484.       ReOrder
  485.       Valuation
  486.  
  487.  
  488.             ╔═[ Single Warehouse ]═══════════════════════════════╗
  489.             ║                                                    ║
  490.             ║ Single Expanded Inventory Warehouse Report.        ║
  491.             ║ Not a Report Form.                                 ║
  492.             ║ Uses Databases: INV.DBF, WAREHOUS.DBF,             ║
  493.             ║                 & WARENAME.DBF.                    ║
  494.             ║                                                    ║
  495.             ╚════════════════════════════════════════════════════╝
  496.  
  497.  
  498.             ╔═[ Single Warehouse ]═══════════════════════════════╗
  499.             ║                                                    ║
  500.             ║ Enter Location:  LOC 1                             ║
  501.             ║ Include 'Ok' Items? (Y/N)                          ║
  502.             ║ Send Output to Printer? (Y/N)                      ║
  503.             ║                          ( No -> To File)          ║
  504.             ║ Enter File Name:  SINGLE.TXT                       ║
  505.             ╚════════════════════════════════════════════════════╝
  506.  
  507.  
  508.    DAYO Smart Reports,     TJS LAB                                   Page: 8
  509.  
  510.  
  511.  
  512.  ■ VALUATION EXPANDED REPORT
  513.  
  514.  
  515.       The Valuation Expanded Report is essentially the same as the Inventory
  516.   Expanded report except that the Valuation is included. A dBase (tm)
  517.   compatible report form is required (VALUATIO.FRM).
  518.  
  519.  
  520.       The following fields/variables are included on this report:
  521.  
  522.           ITEM              ONORDER       VALUATION
  523.           VENDOR ITEM       COST          TYPE
  524.           DESCRIPTION       RETAIL        CLASS
  525.           ONHAND            PRICE
  526.  
  527.  
  528.  
  529.       The first prompt is to select the index (order of the report):
  530.  
  531.  
  532.            ╔══════════════════════════════════════════════════════╗
  533.            ║The Default Valuation Inventory Report (VALUATIO.FRM) ║
  534.            ║contains the following fields/variables:              ║
  535.            ║              ITEM           COST                     ║
  536.            ║              DESC           RETAIL                   ║
  537.            ║              ONHAND         PRICE                    ║
  538.            ║              ONORDER        TYPE                     ║
  539.            ║              VENDITEM       CLASS                    ║
  540.            ║              VALUATION                               ║
  541.            ║                                                      ║
  542.            ║Select the Index -> ITEM        (ITEM)                ║
  543.            ║                    DESCRIPTION (DESC)                ║
  544.            ║                    VENDOR CODE (VENDOR)              ║
  545.            ║                    VENDOR ITEM (VENDITEM)            ║
  546.            ║                    TYPE        (TYPE)                ║
  547.            ║                                                      ║
  548.            ║                                                      ║
  549.            ║                                                      ║
  550.            ║                                                      ║
  551.            ╚══════════════════════════════════════════════════════╝
  552.  
  553.    DAYO Smart Reports,     TJS LAB                                   Page: 9
  554.  
  555.  
  556.  
  557.       The second prompt is for a 'filter' or condition. The filter must/can be
  558.   any valid dBase (tm) expression. To include all records (no filter), just
  559.   press enter on an empty (blank) prompt...
  560.  
  561.  
  562.            ╔══════════════════════════════════════════════════════╗
  563.            ║The Default Valuation Inventory Report (VALUATIO.FRM) ║
  564.            ║contains the following fields/variables:              ║
  565.            ║              ITEM           COST                     ║
  566.            ║              DESC           RETAIL                   ║
  567.            ║              ONHAND         PRICE                    ║
  568.            ║              ONORDER        TYPE                     ║
  569.            ║              VENDITEM       CLASS                    ║
  570.            ║              VALUATION                               ║
  571.            ║                                                      ║
  572.            ║Select the Index -> ITEM        (ITEM)                ║
  573.            ║                                                      ║
  574.            ║Enter Filter:  PRICE>100.00                           ║
  575.            ║EG:  TYPE = "XXX"                                     ║
  576.            ║                                                      ║
  577.            ║Enter Heading: TJS LAB                                ║
  578.            ║Send Output to Printer? (Y/N)       ( No -> To File)  ║
  579.            ║Enter File Name:  VALUE.TXT                           ║
  580.            ║                                                      ║
  581.            ╚══════════════════════════════════════════════════════╝
  582.    DAYO Smart Reports,     TJS LAB                                   Page: 10
  583.  
  584.  
  585.  
  586.  ■ REORDER REPORT  -  2, 4, OR 8 WEEKS AVERAGE
  587.  
  588.       This ReOrder Report calculates and optionally resets the STOCKLEVEL
  589.   field in the database INV.DBF based on sales data (from the DAYO POS
  590.   database DETAIL.DBF). You select the number of weeks stockage (2, 4, or
  591.   8 weeks).
  592.  
  593.       This report does not utilize a report form.
  594.  
  595.  
  596.       The following fields/variables are included on this report:
  597.  
  598.           ITEM              STOCKLEVEL      REORDER
  599.           VENDOR ITEM       COST            EXTENDED COST
  600.           DESCRIPTION       RETAIL          CLASS
  601.           ONHAND            PRICE           TYPE
  602.  
  603.  
  604.  
  605.             ╔═[ ReOrder (2 weeks) ]══════════════════════════════╗
  606.             ║                                                    ║
  607.             ║ ReOrder Based On Last 2 Weeks Sales.               ║
  608.             ║ Not a Report Form.                                 ║
  609.             ║ Uses Databases: INV.DBF, DETAIL.DBF.               ║
  610.             ║ Optionally Resets the StockLevel Field.            ║
  611.             ║                                                    ║
  612.             ╚════════════════════════════════════════════════════╝
  613.  
  614.  
  615.             ╔═[ ReOrder (8 weeks) ]══════════════════════════════╗
  616.             ║                                                    ║
  617.             ║ Reset the StockLevel Field?  (Y/N)                 ║
  618.             ║                                                    ║
  619.             ║ Send Output to Printer? (Y/N)                      ║
  620.             ║                          ( No -> To File)          ║
  621.             ║ Enter File Name:  REORDER8.TXT                     ║
  622.             ╚════════════════════════════════════════════════════╝
  623.  
  624.  
  625.  
  626.       The progress of the reorder report is display with a graph...
  627.  
  628.  
  629.     0 Records                           2                                3
  630.     ╔════════════════╦══════════════════╦═════════════════╦════════════════╗
  631.     ╠███████████████████████════════════╬═════════════════╬════════════════╣
  632.     ╠════════════════╩══════════════════╬═════════════════╩════════════════╣
  633.     0% Completed                        50%                              Done!
  634.  
  635.    DAYO Smart Reports,     TJS LAB                                   Page: 11
  636.  
  637.  
  638.  
  639.  ■ STOCKLEVEL SHORTAGE REPORT
  640.  
  641.       The StockLevel Shortage Report will alert you to any item that falls
  642.   below the stockage level in the main inventory database INV.DBF. The
  643.   algorithm/formula is to report all items when ONHAND is less than the
  644.   STOCKLEVEL.
  645.  
  646.       This report does use a report form (INVSTOCK.FRM), and it is highly
  647.   recommended that you modify it (with dBase III+/IV), if you want to use your
  648.   other warehouses (WAREHOUS.DBF), in the calculation.
  649.  
  650.       The following fields/variables are included on this report:
  651.  
  652.  
  653.                    ITEM           ONHAND         RETAIL
  654.                    VENDITEM       LEVEL          PRICE
  655.                    DESC           ONORDER        TYPE
  656.                    VENDOR         COST
  657.  
  658.  
  659.  
  660.             ╔═[ StockLevel Shortage ]════════════════════════════╗
  661.             ║                                                    ║
  662.             ║ StockLevel Shortage Report.                        ║
  663.             ║ Reports ONHAND < STOCKLEVEL.                       ║
  664.             ║ Uses a Report Form:  INVSTOCK.FRM.                 ║
  665.             ║ Uses Database: INV.DBF.                            ║
  666.             ║                                                    ║
  667.             ╚════════════════════════════════════════════════════╝
  668.  
  669.             ╔═[ StockLevel Shortage ]════════════════════════════╗
  670.             ║                                                    ║
  671.             ║ Select the Index -> ITEM        (ITEM)             ║
  672.             ║ Send Output to Printer? (Y/N)                      ║
  673.             ║                          ( No -> To File)          ║
  674.             ║                                                    ║
  675.             ║ Enter File Name:  INVSHORT.TXT                     ║
  676.             ╚════════════════════════════════════════════════════╝
  677.    DAYO Smart Reports,     TJS LAB                                   Page: 12
  678.  
  679.  
  680.  
  681.  ■ STOCKLEVEL OVER REPORT
  682.  
  683.       The StockLevel Over Report will alert you to any item that is excess
  684.   in the main inventory database INV.DBF. The algorithm/formula is to report
  685.   all items when ONHAND is greater than the STOCKLEVEL.
  686.  
  687.       This report does use a report form (INVSTOCK.FRM), and it is highly
  688.   recommended that you modify it (with dBase III+/IV), if you want to use your
  689.   other warehouses (WAREHOUS.DBF), in the calculation.
  690.  
  691.  
  692.       The following fields/variables are included on the STOCK OVER report:
  693.  
  694.  
  695.                    ITEM           ONHAND         RETAIL
  696.                    VENDITEM       LEVEL          PRICE
  697.                    DESC           ONORDER        TYPE
  698.                    VENDOR         COST
  699.  
  700.  
  701.  
  702.             ╔═[ StockLevel Over ]════════════════════════════════╗
  703.             ║                                                    ║
  704.             ║ StockLevel Over Report.                            ║
  705.             ║ Reports ONHAND > STOCKLEVEL.                       ║
  706.             ║ Uses a Report Form:  INVSTOCK.FRM.                 ║
  707.             ║ Uses Database: INV.DBF.                            ║
  708.             ║                                                    ║
  709.             ╚════════════════════════════════════════════════════╝
  710.  
  711.  
  712.             ╔═[ StockLevel Over ]════════════════════════════════╗
  713.             ║                                                    ║
  714.             ║ Select the Index -> ITEM        (ITEM)             ║
  715.             ║ Send Output to Printer? (Y/N)                      ║
  716.             ║                          ( No -> To File)          ║
  717.             ║                                                    ║
  718.             ║ Enter File Name:  INVOVER.TXT                      ║
  719.             ╚════════════════════════════════════════════════════╝
  720.    DAYO Smart Reports,     TJS LAB                                   Page: 13
  721.  
  722.  
  723.  
  724.  ■ INVENTORY ASCII TEXT
  725.  
  726.       If there exists a need to import inventory fields into a word processor
  727.   or editor, you can use this report to create an ASCII/text file in the
  728.   Standard Data Format (SDF). This format is often called a flat file. Other
  729.   'flat' files/reports can be created with the LIST option in the MISC
  730.   ROUTINES.
  731.  
  732.  
  733.       The format for the file is:
  734.  
  735.                      Field          Len    Start    Stop
  736.                      -----------    ---    -----    ----
  737.                      ITEM           12      1       12
  738.                      VENDITEM       12      13      24
  739.                      DESC           30      25      54
  740.                      VENDOR         10      55      64
  741.                      ONHAND         7       65      71
  742.                      COST           10      72      81
  743.                      PRICE          10      82      91
  744.                      RETAIL         10      92      101
  745.                      STOCKLEVEL     7       102     108
  746.                      TYPE           3       109     111
  747.                      CLASS          3       112     114
  748.  
  749.  
  750.  
  751.             ╔═[ Inventory ASCII Text ]═══════════════════════════╗
  752.             ║                                                    ║
  753.             ║ Inventory ASCII Text File.                         ║
  754.             ║ Creates an ASCII text file for                     ║
  755.             ║ import into a work processor or                    ║
  756.             ║ spreadsheet.                                       ║
  757.             ║                                                    ║
  758.             ╚════════════════════════════════════════════════════╝
  759.  
  760.             ╔═[ Inventory ASCII Text ]═══════════════════════════╗
  761.             ║                                                    ║
  762.             ║ Select the Index -> ITEM        (ITEM)             ║
  763.             ║                                                    ║
  764.             ║ Enter File Name:  INVASCII.TXT                     ║
  765.             ║                                                    ║
  766.             ║                                                    ║
  767.             ╚════════════════════════════════════════════════════╝
  768.    DAYO Smart Reports,     TJS LAB                                   Page: 14
  769.  
  770.  
  771.  
  772.  ■ LATE PURCHASE ORDER REPORT
  773.  
  774.  
  775.       This report simply reports any purchase order that is overdue to be
  776.   received. This report will only work if the ETA (Estimate time [date]),
  777.   field in the database POH.DBF (Purchase Order Headers), is maintain.
  778.  
  779.  
  780.       A report form is used (LATEPO.FRM).
  781.  
  782.  
  783.       Fields/variables in the report:
  784.  
  785.       PO               DESC                      DATE (of PO)
  786.       VENDOR           ORDERED                   ETA
  787.       ITEM             RECEIVED                  LATE (Number of days overdue)
  788.       VENDITEM         DUE (Amount due in)
  789.  
  790.  
  791.  
  792.             ╔═[ Late PO ]════════════════════════════════════════╗
  793.             ║                                                    ║
  794.             ║ Late Purchase Order Report.                        ║
  795.             ║ Reports Date > ETA.                                ║
  796.             ║ Uses a Report Form: LATEPO.FRM.                    ║
  797.             ║ Uses Databases: POD.DBF.                           ║
  798.             ║                                                    ║
  799.             ╚════════════════════════════════════════════════════╝
  800.  
  801.  
  802.  
  803.             ╔═[ Late PO ]════════════════════════════════════════╗
  804.             ║                                                    ║
  805.             ║ Select the Index -> ITEM                           ║
  806.             ║                                                    ║
  807.             ║ Send Output to Printer? (Y/N)                      ║
  808.             ║                          ( No -> To File)          ║
  809.             ║ Enter File Name:  LATEPO.TXT                       ║
  810.             ╚════════════════════════════════════════════════════╝
  811.    DAYO Smart Reports,     TJS LAB                                   Page: 15
  812.  
  813.  
  814.  
  815.  ■ PURCHASE ORDER DUE IN REPORT
  816.  
  817.  
  818.       This report will give you advance notice of the due dates/arrival of
  819.   product from your vendors. This report requires the maintenance of the ETA
  820.   field in the database POH.DBF (Purchase Order Headers).
  821.  
  822.  
  823.       Fields/variables in the report:
  824.  
  825.       PO              DESC                      DATE (of PO)
  826.       VENDOR          ORDERED                   ETA
  827.       ITEM            RECEIVED                  DUE (Number of days overdue)
  828.       VENDITEM        DUE (Amount due in)
  829.  
  830.  
  831.  
  832.             ╔═[ PO - Due In This Week ]══════════════════════════╗
  833.             ║                                                    ║
  834.             ║ PO - Due In This Week Report.                      ║
  835.             ║ Reports Purchase Orders Due to be received within  ║
  836.             ║ the next 7 days.                                   ║
  837.             ║ Uses Report Form: PODUEIN.FRM.                     ║
  838.             ║ Uses Databases: POH.DBF & POD.DBF.                 ║
  839.             ╚════════════════════════════════════════════════════╝
  840.  
  841.  
  842.  
  843.             ╔═[ PO - Due In This Week ]══════════════════════════╗
  844.             ║                                                    ║
  845.             ║ Select the Index -> PO                             ║
  846.             ║                                                    ║
  847.             ║ Send Output to Printer? (Y/N)                      ║
  848.             ║                          ( No -> To File)          ║
  849.             ║ Enter File Name:  PODUEIN.TXT                      ║
  850.             ╚════════════════════════════════════════════════════╝
  851.    DAYO Smart Reports,     TJS LAB                                   Page: 16
  852.  
  853.  
  854.  
  855.  ■ INVENTORY ZERO COST ITEMS REPORT
  856.  
  857.  
  858.       This Smart Report will report only items with a cost less than or equal
  859.   to zero. Use this report to insure you have no items listed in your
  860.   inventory database without a cost value.
  861.  
  862.  
  863.       The report form ZEROCOST.FRM is utilized.
  864.  
  865.  
  866.       The following fields/variables are included in the report:
  867.  
  868.  
  869.  
  870.                       ITEM           ONHAND         PRICE
  871.                       VENDITEM       ONORDER        TYPE
  872.                       DESC           COST           CLASS
  873.                       VENDOR         RETAIL
  874.  
  875.  
  876.  
  877.             ╔═[ Inventory Zero Cost ]════════════════════════════╗
  878.             ║                                                    ║
  879.             ║ Inventory Zero Cost Items Report.                  ║
  880.             ║ Reports any inventory item with a COST <= 0.       ║
  881.             ║ Uses a Report Form: ZEROCOST.FRM.                  ║
  882.             ║ Uses Databases: INV.DBF.                           ║
  883.             ║                                                    ║
  884.             ╚════════════════════════════════════════════════════╝
  885.  
  886.             ╔═[ Inventory Zero Cost ]════════════════════════════╗
  887.             ║                                                    ║
  888.             ║ Select the Index -> ITEM        (ITEM)             ║
  889.             ║                                                    ║
  890.             ║ Send Output to Printer? (Y/N)                      ║
  891.             ║                          ( No -> To File)          ║
  892.             ║ Enter File Name:  0COST.TXT                        ║
  893.             ╚════════════════════════════════════════════════════╝
  894.    DAYO Smart Reports,     TJS LAB                                   Page: 17
  895.  
  896.  
  897.  
  898.  ■ INVENTORY ZERO PRICE ITEMS REPORT
  899.  
  900.  
  901.       This Smart Report will report only items with a price less than or equal
  902.   to zero. Use this report to insure you have no items listed in your
  903.   inventory database without a price value.
  904.  
  905.  
  906.       The report form ZEROCOST.FRM is utilized.
  907.  
  908.  
  909.       The following fields/variables are included in the report:
  910.  
  911.  
  912.                       ITEM           ONHAND         PRICE
  913.                       VENDITEM       ONORDER        TYPE
  914.                       DESC           COST           CLASS
  915.                       VENDOR         RETAIL
  916.  
  917.  
  918.  
  919.             ╔═[ Inventory Zero Price ]═══════════════════════════╗
  920.             ║                                                    ║
  921.             ║ Inventory Zero Price Items Report.                 ║
  922.             ║ Reports any inventory item with a PRICE <= 0.      ║
  923.             ║ Uses a Report Form: ZEROCOST.FRM.                  ║
  924.             ║ Uses Databases: INV.DBF.                           ║
  925.             ║                                                    ║
  926.             ╚════════════════════════════════════════════════════╝
  927.  
  928.  
  929.  
  930.             ╔═[ Inventory Zero Price ]═══════════════════════════╗
  931.             ║                                                    ║
  932.             ║ Select the Index -> ITEM        (ITEM)             ║
  933.             ║                                                    ║
  934.             ║ Send Output to Printer? (Y/N)                      ║
  935.             ║                          ( No -> To File)          ║
  936.             ║ Enter File Name:  0PRICE.TXT                       ║
  937.             ╚════════════════════════════════════════════════════╝
  938.    DAYO Smart Reports,     TJS LAB                                   Page: 18
  939.  
  940.  
  941.  
  942.  ■ INVENTORY ZERO RETAIL ITEMS REPORT
  943.  
  944.  
  945.       This Smart Report will report only items with a retail/list 'price'
  946.   less than or equal to zero. Use this report to insure you have no items
  947.   listed in your inventory database without a retail/list value.
  948.  
  949.  
  950.       The report form ZEROCOST.FRM is utilized.
  951.  
  952.  
  953.       The following fields/variables are included in the report:
  954.  
  955.  
  956.                       ITEM           ONHAND         PRICE
  957.                       VENDITEM       ONORDER        TYPE
  958.                       DESC           COST           CLASS
  959.                       VENDOR         RETAIL
  960.  
  961.  
  962.  
  963.             ╔═[ Inventory Zero Retail ]══════════════════════════╗
  964.             ║                                                    ║
  965.             ║ Inventory Zero Retail Items Report.                ║
  966.             ║ Reports any inventory item with a RETAIL <= 0.     ║
  967.             ║ Uses a Report Form: ZEROCOST.FRM.                  ║
  968.             ║ Uses Databases: INV.DBF.                           ║
  969.             ║                                                    ║
  970.             ╚════════════════════════════════════════════════════╝
  971.  
  972.  
  973.  
  974.             ╔═[ Inventory Zero Retail ]══════════════════════════╗
  975.             ║                                                    ║
  976.             ║ Select the Index -> ITEM        (ITEM)             ║
  977.             ║                                                    ║
  978.             ║ Send Output to Printer? (Y/N)                      ║
  979.             ║                          ( No -> To File)          ║
  980.             ║ Enter File Name:  0RETAIL.TXT                      ║
  981.             ╚════════════════════════════════════════════════════╝
  982.    DAYO Smart Reports,     TJS LAB                                   Page: 19
  983.  
  984.  
  985.  
  986.  ■ NEGATIVE ONHAND REPORT
  987.  
  988.  
  989.       This report will alert you to a posting problem (probably with DAYO
  990.   POS).  It is not recommended that invoices be created without items in the
  991.   inventory database (INV.DBF), however it is an optional DAYO Inventory
  992.   configuration setting to allow/disallow it.
  993.  
  994.  
  995.       The report form NEGQTY.FRM is utilized.
  996.  
  997.  
  998.       The following fields/variables are included in the report:
  999.  
  1000.  
  1001.                       ITEM           ONHAND         PRICE
  1002.                       VENDITEM       ONORDER        TYPE
  1003.                       DESC           COST           CLASS
  1004.                       VENDOR         RETAIL
  1005.  
  1006.  
  1007.  
  1008.             ╔═[ Negative Onhand ]════════════════════════════════╗
  1009.             ║                                                    ║
  1010.             ║ Inventory Negative Onhand Report.                  ║
  1011.             ║ Reports any inventory item with an ONHAND < 0.     ║
  1012.             ║ Uses a Report Form: NEGQTY.FRM.                    ║
  1013.             ║ Uses Databases: INV.DBF.                           ║
  1014.             ║                                                    ║
  1015.             ╚════════════════════════════════════════════════════╝
  1016.  
  1017.  
  1018.  
  1019.             ╔═[ Negative Onhand ]════════════════════════════════╗
  1020.             ║                                                    ║
  1021.             ║ Select the Index -> ITEM        (ITEM)             ║
  1022.             ║                                                    ║
  1023.             ║ Send Output to Printer? (Y/N)                      ║
  1024.             ║                          ( No -> To File)          ║
  1025.             ║ Enter File Name:  NEGQTY.TXT                       ║
  1026.             ╚════════════════════════════════════════════════════╝
  1027.    DAYO Smart Reports,     TJS LAB                                   Page: 20
  1028.  
  1029.  
  1030.  
  1031.  ■ MARGIN HISTORY  (AVERAGE MARGIN & COST)
  1032.  
  1033.  
  1034.       Use this report on the occasions that you need to know the average
  1035.   margin for your inventory items based on the total sales history. The
  1036.   average cost is also calculated. Knowing these values is often necessary in
  1037.   determining the PRICE.
  1038.  
  1039.  
  1040.       No report form is utilized.
  1041.  
  1042.  
  1043.       The following fields/variables are included in the report:
  1044.  
  1045.  
  1046.                          ITEM             PRICE
  1047.                          VENDITEM         RETAIL
  1048.                          DESC             AVERAGE COST
  1049.                          COST             MARGIN
  1050.  
  1051.  
  1052.  
  1053.             ╔═[ Margin (History) ]═══════════════════════════════╗
  1054.             ║                                                    ║
  1055.             ║ Item Average Margin (All Sales History).           ║
  1056.             ║ Report of the average sales margin for an item.    ║
  1057.             ║ Uses a Report Form: AMARGIN.FRM.                   ║
  1058.             ║ Uses Databases: INV.DBF & DETAIL.DBF.              ║
  1059.             ║                                                    ║
  1060.             ╚════════════════════════════════════════════════════╝
  1061.  
  1062.  
  1063.  
  1064.             ╔═[ Margin (History) ]═══════════════════════════════╗
  1065.             ║                                                    ║
  1066.             ║ Select the Index -> ITEM        (ITEM)             ║
  1067.             ║                                                    ║
  1068.             ║ Send Output to Printer? (Y/N)                      ║
  1069.             ║                          ( No -> To File)          ║
  1070.             ║ Enter File Name:  AMARGIN.TXT                      ║
  1071.             ╚════════════════════════════════════════════════════╝
  1072.    DAYO Smart Reports,     TJS LAB                                   Page: 21
  1073.  
  1074.  
  1075.  
  1076.  ■ MARGIN HISTORY  (LAST 12 WEEKS)
  1077.  
  1078.  
  1079.       Use this report on the occasions that you need to know the average
  1080.   margin for your inventory items based on the last 12 weeks of sales history.
  1081.   The average cost is also calculated. Knowing these values is often necessary
  1082.   in determining the PRICE.
  1083.  
  1084.  
  1085.       No report form is utilized.
  1086.  
  1087.  
  1088.       The following fields/variables are included in the report:
  1089.  
  1090.  
  1091.                          ITEM             PRICE
  1092.                          VENDITEM         RETAIL
  1093.                          DESC             AVERAGE COST
  1094.                          COST             MARGIN
  1095.  
  1096.  
  1097.             ╔═[ Margin (12 Weeks) ]══════════════════════════════╗
  1098.             ║                                                    ║
  1099.             ║ Item Average Margin (Last 12 Weeks History).       ║
  1100.             ║ Report of the average sales margin for an item     ║
  1101.             ║ using the last 12 weeks of sales data.             ║
  1102.             ║ Uses a Report Form: AMARGIN.FRM.                   ║
  1103.             ║ Uses Databases: INV.DBF & DETAIL.DBF.              ║
  1104.             ╚════════════════════════════════════════════════════╝
  1105.  
  1106.  
  1107.  
  1108.             ╔═[ Margin (12 Weeks) ]══════════════════════════════╗
  1109.             ║                                                    ║
  1110.             ║ Select the Index -> ITEM        (ITEM)             ║
  1111.             ║                                                    ║
  1112.             ║ Send Output to Printer? (Y/N)                      ║
  1113.             ║                          ( No -> To File)          ║
  1114.             ║ Enter File Name:  AMARGIN.TXT                      ║
  1115.             ╚════════════════════════════════════════════════════╝
  1116.    DAYO Smart Reports,     TJS LAB                                   Page: 22
  1117.  
  1118.  
  1119.  
  1120.  ■ VENDOR LIST
  1121.  
  1122.       This is a simple listing of your vendors.
  1123.  
  1124.       Uses the report form VENDLIST.FRM.
  1125.  
  1126.       The following fields/variables are included in the report:
  1127.  
  1128.                    VENDOR    NAME    DATE    PHONE
  1129.  
  1130.  
  1131.             ╔═[ Vendor List ]════════════════════════════════════╗
  1132.             ║                                                    ║
  1133.             ║ Vendor List.                                       ║
  1134.             ║                                                    ║
  1135.             ║ Uses a Report Form: VENDLIST.FRM.                  ║
  1136.             ║ Uses Database: VENDORS.DBF.                        ║
  1137.             ║                                                    ║
  1138.             ╚════════════════════════════════════════════════════╝
  1139.  
  1140.  
  1141.             ╔═[ Vendor List ]════════════════════════════════════╗
  1142.             ║                                                    ║
  1143.             ║                                                    ║
  1144.             ║ Send Output to Printer? (Y/N)                      ║
  1145.             ║                          ( No -> To File)          ║
  1146.             ║                                                    ║
  1147.             ║ Enter File Name:  VENDLIST.TXT                     ║
  1148.             ╚════════════════════════════════════════════════════╝
  1149.  
  1150.  
  1151.  
  1152.  ■ EXAMPLE OF THE VENDOR LIST
  1153.  
  1154.  
  1155.         Page No.     1
  1156.         07/27/90
  1157.                                     Vendors Listing
  1158.         
  1159.                                                                               
  1160.         Vendor                                    Last                        
  1161.         Number     Vendor Name                    Date     Phone              
  1162.         ---------- ------------------------------ -------- --------------     
  1163.         
  1164.         
  1165.         3M         3M TAPES                       07/03/90 24             ____
  1166.         6MM        6M MAINTENANCE CO              07/03/90 24             ____
  1167.         ABC        AL'S BEVERAGE COMPANY          07/03/90 24             ____
  1168.         RDD        RESEACH DEV. DIST. CENTER      07/03/90 24             ____
  1169.         ROC        REPUBLIC OF CHINA              07/03/90 24             ____
  1170.         SSS        SIERRA SUPPLY & SERVICES       07/03/90 24             ____
  1171.         TLJ        TJS LAB                        07/03/90 24             ____
  1172.    DAYO Smart Reports,     TJS LAB                                   Page: 23
  1173.  
  1174.  
  1175.  
  1176.  ■ CUSTOMER LIST
  1177.  
  1178.  
  1179.       This is a simple listing of your customers.
  1180.  
  1181.       Uses the report form CUSTLIST.FRM.
  1182.  
  1183.       The following fields/variables are included in the report:
  1184.                                                                             
  1185.                     CUSTOMER      NAME      PHONE
  1186.         
  1187.  
  1188.             ╔═[ Customer List ]══════════════════════════════════╗
  1189.             ║                                                    ║
  1190.             ║ Customer List.                                     ║
  1191.             ║                                                    ║
  1192.             ║ Uses a Report Form: CUSTLIST.FRM.                  ║
  1193.             ║ Uses Database: VENDORS.DBF.                        ║
  1194.             ║                                                    ║
  1195.             ╚════════════════════════════════════════════════════╝
  1196.  
  1197.             ╔═[ Customer List ]══════════════════════════════════╗
  1198.             ║                                                    ║
  1199.             ║                                                    ║
  1200.             ║ Send Output to Printer? (Y/N)                      ║
  1201.             ║                          ( No -> To File)          ║
  1202.             ║                                                    ║
  1203.             ║ Enter File Name:  CUSTLIST.TXT                     ║
  1204.             ╚════════════════════════════════════════════════════╝
  1205.  
  1206.  
  1207.  
  1208.  ■ EXAMPLE OF THE CUSTOMER LIST
  1209.  
  1210.  
  1211.         Page No.     1
  1212.         07/27/90
  1213.                                      Customer List
  1214.         
  1215.                                                                             
  1216.                                                                             
  1217.         Customer Name                           Phone                       
  1218.         -------- ------------------------------ --------------              
  1219.         
  1220.         
  1221.           301210 DASHER, DON                    744-4541       _____________
  1222.           301211 DASHLEY COURT                                 _____________
  1223.           301212 MRS. BERT                                     _____________
  1224.           301213 KALUMINEX                      743-8634       _____________
  1225.           301214 ADVANCED ELECTRONICS                          _____________
  1226.           301215 DENNYS CONSTRUCTION            740-6741       _____________
  1227.           301216 BARKALOW, ROB                  846-4169       _____________
  1228.           301218 BURGER KING                    744-3332       _____________
  1229.           301219 MALLO CONSTRUCTION CO                         _____________
  1230.    DAYO Smart Reports,     TJS LAB                                   Page: 24
  1231.  
  1232.  
  1233.  
  1234.  ■ INVENTORY ITEM LIST
  1235.  
  1236.       This is a listing of your inventory items.
  1237.  
  1238.       Uses the report form ITEMLIST.FRM.
  1239.  
  1240.       The following fields/variables are included in the report:
  1241.  
  1242.                      ITEM      VENDITEM      DESC
  1243.  
  1244.  
  1245.             ╔═[ Inventory Item List ]════════════════════════════╗
  1246.             ║                                                    ║
  1247.             ║ Inventory Item List.                               ║
  1248.             ║                                                    ║
  1249.             ║ Uses a Report Form: ITEMLIST.FRM.                  ║
  1250.             ║ Uses Database: INV.DBF.                            ║
  1251.             ║                                                    ║
  1252.             ╚════════════════════════════════════════════════════╝
  1253.  
  1254.  
  1255.             ╔═[ Inventory Item List ]════════════════════════════╗
  1256.             ║                                                    ║
  1257.             ║                                                    ║
  1258.             ║ Send Output to Printer? (Y/N)                      ║
  1259.             ║                          ( No -> To File)          ║
  1260.             ║                                                    ║
  1261.             ║ Enter File Name:  ITEMLIST.TXT                     ║
  1262.             ╚════════════════════════════════════════════════════╝
  1263.  
  1264.  
  1265.  
  1266.  ■ EXAMPLE OF THE INVENTORY ITEM LIST
  1267.  
  1268.  
  1269.         Page No.     1
  1270.         07/27/90
  1271.                                  INVENTORY ITEM LISTING
  1272.         
  1273.                                                                               
  1274.                      Vendor or                                                
  1275.         Item         Mfg Item     Description                                 
  1276.         ------------ ------------ ------------------------------              
  1277.         
  1278.         2" GUTTER                 2" GUTTER SYSTEM               _____________
  1279.         2ALM518                   2" ALMOND COIL                 _____________
  1280.         2ALM519                   2" ALMOND COIL                 _____________
  1281.         2ALM527                   2" ALMOND COIL                 _____________
  1282.         2ALM533                   2" ALMOND COIL                 _____________
  1283.         2ANT123                   2" ANT IVORY COIL              _____________
  1284.         2ANT143                   2" ANT IVORY COIL              _____________
  1285.         2ANT148                   2" ANT IVORY COIL              _____________
  1286.    DAYO Smart Reports,     TJS LAB                                   Page: 25
  1287.  
  1288.  
  1289.  
  1290.  ■ CHECKING ACCOUNT LIST
  1291.  
  1292.       This is a listing of your inventory items.
  1293.  
  1294.       Uses the report form ACCTLIST.FRM.
  1295.  
  1296.       The following fields/variables are included in the report:
  1297.  
  1298.              NUMBER       ACCTNUM       NAME       BALANCE
  1299.  
  1300.  
  1301.  
  1302.             ╔═[ Checking Account List ]══════════════════════════╗
  1303.             ║                                                    ║
  1304.             ║ Checking Account List.                             ║
  1305.             ║                                                    ║
  1306.             ║ Uses a Report Form: ACCTLIST.FRM.                  ║
  1307.             ║ Uses Database: ACCOUNTS.DBF.                       ║
  1308.             ║                                                    ║
  1309.             ╚════════════════════════════════════════════════════╝
  1310.  
  1311.  
  1312.             ╔═[ Checking Account List ]══════════════════════════╗
  1313.             ║                                                    ║
  1314.             ║                                                    ║
  1315.             ║ Send Output to Printer? (Y/N)                      ║
  1316.             ║                          ( No -> To File)          ║
  1317.             ║                                                    ║
  1318.             ║ Enter File Name:  ACCTLIST.TXT                     ║
  1319.             ╚════════════════════════════════════════════════════╝
  1320.  
  1321.  
  1322.  
  1323.  ■ EXAMPLE OF THE CHECKING ACCOUNT LIST
  1324.  
  1325.  
  1326.         Page No.     1
  1327.         07/27/90
  1328.                                CHECKING ACCOUNTS LISTING
  1329.         
  1330.                                                                              
  1331.                Account                                                       
  1332.         Number Number               Bank/Account Name                 Balance
  1333.         ------ -------------------- ------------------------------ ----------
  1334.         
  1335.         
  1336.         1      0100983-28838-20     C&S National Bank, Orlando       12980.17
  1337.         2      12321-1232-XA        CAPONES Private Bank                15.00
  1338.         *** Total ***
  1339.                                                                      12995.12
  1340.    DAYO Smart Reports,     TJS LAB                                   Page: 26
  1341.  
  1342.  
  1343.  ■ CHECK FORMAT LIST
  1344.  
  1345.       This is a listing of all your check formats (the printer settings for
  1346.   the printing of special/custom checks). Only the length and width of the
  1347.   check form is printed...
  1348.  
  1349.       Uses the report form CHKFLIST.FRM.
  1350.  
  1351.       The following fields/variables are included in the report:
  1352.  
  1353.             FORMAT      NAME      CHECK LENGTH      CHECK WIDTH
  1354.  
  1355.  
  1356.             ╔═[ Check Format List ]══════════════════════════════╗
  1357.             ║                                                    ║
  1358.             ║ Check Format List of all your 'Unique'             ║
  1359.             ║ Check Formats.                                     ║
  1360.             ║ Uses a Report Form: CHKFLIST.FRM.                  ║
  1361.             ║ Uses Database: CFORMAT.DBF.                        ║
  1362.             ║                                                    ║
  1363.             ╚════════════════════════════════════════════════════╝
  1364.  
  1365.             ╔═[ Check Format List ]══════════════════════════════╗
  1366.             ║                                                    ║
  1367.             ║                                                    ║
  1368.             ║ Send Output to Printer? (Y/N)                      ║
  1369.             ║                          ( No -> To File)          ║
  1370.             ║                                                    ║
  1371.             ║ Enter File Name:  CHKFLIST.TXT                     ║
  1372.             ╚════════════════════════════════════════════════════╝
  1373.  
  1374.  
  1375.  
  1376.  ■ EXAMPLE OF THE CHECKING ACCOUNT FORMATS LIST
  1377.  
  1378.  
  1379.         Page No.     1
  1380.         07/27/90
  1381.                              CHECKING ACCOUNT FORMATS LIST
  1382.         
  1383.                                                                              
  1384.                                                Check Check                   
  1385.         Format Name                           Length Width                   
  1386.         ------ ------------------------------ ------ -----                   
  1387.         
  1388.         
  1389.         1      Nebb's Radio Shack Check Type      41    80 __________________
  1390.         2      Moore Check # 1929                 21    80 __________________
  1391.         3      Computer Forms, Inc #93001-A       19    90 __________________
  1392.    DAYO Smart Reports,     TJS LAB                                   Page: 27
  1393.  
  1394.  
  1395.  
  1396.  ■ EXPENSES LIST
  1397.  
  1398.       This is a listing of all your expenses.
  1399.  
  1400.       Uses the report form EXPLIST.FRM.
  1401.  
  1402.       The following fields/variables are included in the report:
  1403.  
  1404.                 WHATFOR     NUMBER     AMOUNT     DATE
  1405.  
  1406.  
  1407.             ╔═[ Expenses List ]══════════════════════════════════╗
  1408.             ║                                                    ║
  1409.             ║ Expenses List of all your 'Unique' Expenses.       ║
  1410.             ║                                                    ║
  1411.             ║ Uses a Report Form: EXPLIST.FRM.                   ║
  1412.             ║ Uses Database: EXPENSES.DBF.                       ║
  1413.             ║                                                    ║
  1414.             ╚════════════════════════════════════════════════════╝
  1415.  
  1416.  
  1417.             ╔═[ Expenses List ]══════════════════════════════════╗
  1418.             ║                                                    ║
  1419.             ║                                                    ║
  1420.             ║ Send Output to Printer? (Y/N)                      ║
  1421.             ║                          ( No -> To File)          ║
  1422.             ║                                                    ║
  1423.             ║ Enter File Name:  EXPLIST.TXT                      ║
  1424.             ╚════════════════════════════════════════════════════╝
  1425.  
  1426.  
  1427.  
  1428.  ■ EXAMPLE OF THE EXPENSES LIST
  1429.  
  1430.  
  1431.   Page No.     1
  1432.   07/27/90
  1433.                                   EXPENSES LIST
  1434.   
  1435.                                                                               
  1436.                                            Expense                            
  1437.   Expense For...                            Number     Amount Date            
  1438.   ---------------------------------------- ------- ---------- --------        
  1439.   
  1440.   
  1441.   Red Bug Exterminators                        120      45.00 12/04/89 _______
  1442.   South Carolina Electric & Gas                121    1245.31 01/17/90 _______
  1443.   Carleton Cars                                122     530.40 01/12/90 _______
  1444.   Joe's Lawn Service                           123      15.00 02/23/90 _______
  1445.   Mary Martin & Associates                     144      50.00 04/14/90 _______
  1446.   *** Total ***
  1447.                                                       1885.71
  1448.  
  1449.    DAYO Smart Reports,     TJS LAB                                   Page: 28
  1450.  
  1451.  
  1452.  
  1453.  ■ WAREHOUSE ADJUSTMENTS REPORT
  1454.  
  1455.  
  1456.       This report list all inventory adjusts for a selected data range that
  1457.   are warehouse related.
  1458.  
  1459.       Uses the report form WAREADJ.FRM
  1460.  
  1461.  
  1462.             ╔═[ Warehouse Adjustments ]══════════════════════════╗
  1463.             ║■Start Date:  01/27/90  Ending Date:  07/27/90      ║
  1464.             ║ Send Output to Printer? (Y/N)                      ║
  1465.             ║                          ( No -> To File)          ║
  1466.             ║ Enter File Name:  WAREADJ.TXT                      ║
  1467.             ║                                                    ║
  1468.             ║                                                    ║
  1469.             ╚════════════════════════════════════════════════════╝
  1470.  
  1471.  
  1472.  
  1473.  ■ EXAMPLE OF THE WAREHOUSE ADJUSTMENTS REPORT
  1474.  
  1475.  
  1476.  Page No.     1
  1477.  07/27/90
  1478.                           WAREHOUSE ADJUSTMENTS REPORT
  1479.  
  1480.  
  1481.  Ware-   Reason                                                Extended
  1482.  House   For             Item         Description        Qty       Cost Date
  1483.  ------- --------------- ------------ --------------- ------ ---------- -----
  1484.  
  1485.  
  1486.  ** Warehouse: LOC1
  1487.  1       Found in the    JAR-1                             3       4.23 12/89
  1488.          receiving area  JAR #1, 30
  1489.  1       Found in the    JAR-2                             1       1.00 12/89
  1490.          receiving area  JAR #2, 10-A
  1491.  1       Returned        JAR-3                             1       1.00 12/89
  1492.                          JAR #3
  1493.  ** Subtotal **
  1494.                                                            5       6.23
  1495.  
  1496.  3       Found in the    JAR-3                             1       1.00 12/89
  1497.          shipping area   JAR #3
  1498.  ** Subtotal **
  1499.                                                            1       1.00
  1500.  *** Total ***
  1501.                                                            6       7.23
  1502.  
  1503.    DAYO Smart Reports,     TJS LAB                                   Page: 29
  1504.  
  1505.  
  1506.  
  1507.  ■ HP LASER PULL SHEET/REPORT WITH FILTER
  1508.  
  1509.       This report will ONLY print onto an HP Laser or a compatible printer!
  1510.  
  1511.       The first prompt is for a 'filter' or condition. The filter must/can be
  1512.   any valid dBase (tm) expression. To include all records (no filter), just
  1513.   press enter on an empty (blank) prompt...
  1514.  
  1515.  
  1516.             ╔═[ HP Laser Pull Sheet ]════════════════════════════╗
  1517.             ║■                                                   ║
  1518.             ║  EG:  TYPE='XXX'                                   ║
  1519.             ║  Enter Filter:  TYPE="ABC"                         ║
  1520.             ║                                                    ║
  1521.             ║                                                    ║
  1522.             ║                                                    ║
  1523.             ╚════════════════════════════════════════════════════╝
  1524.  
  1525.       The Pull Sheet can be printed without any prices, the cost, price, or
  1526.   the retail (list) price...
  1527.  
  1528.             ╔═[ HP Laser Pull Sheet ]════════════════════════════╗
  1529.             ║■Select Pull Sheet -> Pull Sheet - No Costs/Prices  ║
  1530.             ║                      Pull Sheet - Cost             ║
  1531.             ║                      Pull Sheet - Price            ║
  1532.             ║                      Pull Sheet - Retail/List      ║
  1533.             ║                                                    ║
  1534.             ║                                                    ║
  1535.             ╚════════════════════════════════════════════════════╝
  1536.  
  1537.  
  1538.       There exists 8 index options for the Pull Report:
  1539.  
  1540.             1.  Item Number
  1541.             2.  Item Description
  1542.             3.  Vendor Number
  1543.             4.  Vendor/Mfg Item Number
  1544.             5.  Item Type
  1545.             6.  Item CLASS Code
  1546.             7.  Item Cost
  1547.             8.  Location + Item Number
  1548.  
  1549.  
  1550.             ╔═[ HP Laser Pull Sheet ]════════════════════════════╗
  1551.             ║■Select Pull Sheet ->Pull Sheet - No Costs/Prices   ║
  1552.             ║ Select Index -> Item Number                        ║
  1553.             ║                 Item Description                   ║
  1554.             ║ Use the down    Vendor Number                      ║
  1555.             ║ arrow key to    Vendor/Mfg Item Number             ║
  1556.             ║ view more...    Item Type                          ║
  1557.             ╚════════════════════════════════════════════════════╝
  1558.    DAYO Smart Reports,     TJS LAB                                   Page: 30
  1559.  
  1560.  
  1561.  
  1562.       The last 3 index options (CLASS, COST, or LOCATION) require the creation
  1563.   of a temporary index, ie:
  1564.  
  1565.  
  1566.          ┌──────────────────────────────────────────────────────────┐
  1567.          │      Database Name: \DAYOINV\INV.DBF                     │
  1568.          │         Index Name: TEMP51.NTX                           │
  1569.          │  Number of Records: 303                                  │
  1570.          │  ┌──────────────────────────────────────────────────┐    │
  1571.          │  │██████████████████████████████████                │    │
  1572.          │  └──────────────────────────────────────────────────┘    │
  1573.          │  0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 %  │
  1574.          └──────────────────────────────────────────────────────────┘
  1575.  
  1576.  
  1577.  
  1578.       The Pull Sheet can be directed to the printer or to a file (for later
  1579.   printing. Note, this report CAN NOT be viewed onscreen because of the laser
  1580.   printer codes...
  1581.  
  1582.  
  1583.             ╔═[ HP Laser Pull Sheet ]════════════════════════════╗
  1584.             ║■Select Pull Sheet ->Pull Sheet - No Costs/Prices   ║
  1585.             ║ Select Index ->Item CLASS Code                     ║
  1586.             ║ Send Output to Printer? (Y/N)                      ║
  1587.             ║ (Remember, only HP Laser or Compatible)            ║
  1588.             ║ Enter File Name:  PULL.TXT                         ║
  1589.             ║                                                    ║
  1590.             ╚════════════════════════════════════════════════════╝
  1591.  
  1592.  
  1593.       A progress graph is displayed while the report is generated:
  1594.  
  1595.  
  1596.             ╔═[ HP Laser Pull Sheet ]════════════════════════════╗
  1597.             ║■Select Pull Sheet ->Pull Sheet - No Costs/Prices   ║
  1598.             ║ Select Index ->Item Cost                           ║
  1599.             ║ Send Output to Printer? (Y/N)                      ║
  1600.             ║ (Remember, only HP Laser or Compatible)            ║
  1601.             ║  ├███████─┬──┬──┬──┬──┬──┼──┬──┬──┬──┬──┬──┬──┬──┤ ║
  1602.             ║  %                      50%                  finis ║
  1603.             ╚════════════════════════════════════════════════════╝
  1604.    DAYO Smart Reports,     TJS LAB                                   Page: 31
  1605.  
  1606.  
  1607.  
  1608.  ■ INVENTORY EXPANDED REPORT WITH FILTER
  1609.  
  1610.       The first prompt for the Expanded Inventory is for the index (order of
  1611.   the report):
  1612.  
  1613.  
  1614.            ╔═[ Expanded Inventory Report ]════════════════════════╗
  1615.            ║The Default Expanded Inventory Report (EXPANDED.FRM)  ║
  1616.            ║contains the following fields/variables:              ║
  1617.            ║              ITEM           COST                     ║
  1618.            ║              DESC           RETAIL                   ║
  1619.            ║              ONHAND         PRICE                    ║
  1620.            ║              ONORDER        TYPE                     ║
  1621.            ║              VENDITEM       CLASS                    ║
  1622.            ║              VENDOR                                  ║
  1623.            ║                                                      ║
  1624.            ║Select the Index -> ITEM        (ITEM)                ║
  1625.            ║                    DESCRIPTION (DESC)                ║
  1626.            ║                    VENDOR CODE (VENDOR)              ║
  1627.            ║                    VENDOR ITEM (VENDITEM)            ║
  1628.            ║                    TYPE        (TYPE)                ║
  1629.            ║                                                      ║
  1630.            ║                                                      ║
  1631.            ║                                                      ║
  1632.            ║                                                      ║
  1633.            ╚══════════════════════════════════════════════════════╝
  1634.  
  1635.       The second prompt is for a 'filter' or condition. The filter must/can be
  1636.   any valid dBase (tm) expression. To include all records (no filter), just
  1637.   press enter on an empty (blank) prompt...
  1638.  
  1639.            ╔═[ Expanded Inventory Report ]════════════════════════╗
  1640.            ║The Default Expanded Inventory Report (EXPANDED.FRM)  ║
  1641.            ║contains the following fields/variables:              ║
  1642.            ║              ITEM           COST                     ║
  1643.            ║              DESC           RETAIL                   ║
  1644.            ║              ONHAND         PRICE                    ║
  1645.            ║              ONORDER        TYPE                     ║
  1646.            ║              VENDITEM       CLASS                    ║
  1647.            ║              VENDOR                                  ║
  1648.            ║                                                      ║
  1649.            ║Select the Index -> ITEM        (ITEM)                ║
  1650.            ║                                                      ║
  1651.            ║Enter Filter:  CLASS="   "                            ║
  1652.            ║EG:  TYPE = "XXX"                                     ║
  1653.            ║                                                      ║
  1654.            ║Include Zero (0) Cost Items?  (Y/N)                   ║
  1655.            ║Enter Heading: EXPANDED REPORT                        ║
  1656.            ║Send Output to Printer? (Y/N)       ( No -> To File)  ║
  1657.            ║Enter File Name:  EXPANDED.TXT                        ║
  1658.            ╚══════════════════════════════════════════════════════╝
  1659.    DAYO Smart Reports,     TJS LAB                                   Page: 32
  1660.  
  1661.  
  1662.  
  1663.  ■ INVENTORY AVAILABLE REPORT WITH FILTER
  1664.  
  1665.  
  1666.       This report is identical to the Expanded Inventory Report except that
  1667.   it only reports items with an ONHAND quantity not equal to Zero (0).
  1668.  
  1669.  
  1670.            ╔═[ Available Inventory Report ]═══════════════════════╗
  1671.            ║The Available Report only prints items with an ONHAND ║
  1672.            ║not equal to zero. Otherwise the same as the Expanded.║
  1673.            ║              ITEM           COST                     ║
  1674.            ║              DESC           RETAIL                   ║
  1675.            ║              ONHAND         PRICE                    ║
  1676.            ║              ONORDER        TYPE                     ║
  1677.            ║              VENDITEM       CLASS                    ║
  1678.            ║              VENDOR                                  ║
  1679.            ║                                                      ║
  1680.            ║Select the Index -> ITEM        (ITEM)                ║
  1681.            ║                                                      ║
  1682.            ║Enter Filter:  COST>1000                              ║
  1683.            ║EG:  TYPE = "XXX"                                     ║
  1684.            ║                                                      ║
  1685.            ║Include Zero (0) Cost Items?  (Y/N)                   ║
  1686.            ║Enter Heading: AVAILABLE REPORT                       ║
  1687.            ║Send Output to Printer? (Y/N)       ( No -> To File)  ║
  1688.            ║Enter File Name:  AVALABLE.TXT                        ║
  1689.            ╚══════════════════════════════════════════════════════╝
  1690.  
  1691.    DAYO Smart Reports,     TJS LAB                                   Page: 33
  1692.  
  1693.  
  1694.  
  1695.  
  1696.  ■ CHECK FOR DUPLICATE RECORDS/INDEX KEYS
  1697.  
  1698.       This report/routine is used to find duplicate records in any database
  1699.   that is indexed. The prompts are for the database name (you can include the
  1700.   drive/directory/path), and the index name. The routine will determine the
  1701.   index key (the field that created the selected index).
  1702.  
  1703.       If any duplicate records (index key values) are found, a report will
  1704.   be generated (directed to printer or file).
  1705.  
  1706.  
  1707.  
  1708.             ╠═[ Check for Duplicates ]═══════════════════════════╗
  1709.             ║■                                                   ║
  1710.             ║ Enter Database Name:  \DAYOPOS\INVOICE             ║
  1711.             ║    Enter Index Name:  \DAYOPOS\INVOICE             ║
  1712.             ║ Send Output to Printer? (Y/N)                      ║
  1713.             ╣                          ( No -> To File)          ║
  1714.             ║ Enter File Name:  DUPES.TXT                        ║
  1715.             ╩════════════════════════════════════════════════════╝
  1716.  
  1717.  
  1718.       The progress of this routine is displayed onto the screen. If any
  1719.   duplicates are found, a short beep will sound...
  1720.  
  1721.  
  1722.     ╔════[ Duplicate Record Check ]══════════════════════════════════════╗
  1723.     ║ Looking for duplicate KEY fields in the following:                 ║
  1724.     ║ Database \DAYOPOS\INVOICE                                          ║
  1725.     ║    Index \DAYOPOS\INVOICE                                          ║
  1726.     ║     KEY  INVOICE                                                   ║
  1727.     ║ Number of records to search: 111                                   ║
  1728.     ╟██████████████████████████████████████┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──╢
  1729.     ║0                               50%                            Finis║
  1730.     ╚════════════════════════════════════════════════════════════════════╝
  1731.          Standby While I Print This Report!       Press  Esc  to Abort
  1732.  
  1733.  
  1734.  
  1735.  ■ EXAMPLE OF THE DUPLICATE RECORD/INDEX KEY REPORT
  1736.  
  1737.  
  1738.    Duplicate Record Check                                             Page  1
  1739.    Database: \DAYOPOS\INVOICE
  1740.       Index: \DAYOPOS\INVOICE
  1741.         KEY: INVOICE
  1742.  
  1743.    Records 6 & 7 are duplicated:     63
  1744.    Records 7 & 8 are duplicated:     63
  1745.    Records 20 & 21 are duplicated:     77
  1746.    Records 28 & 29 are duplicated:     86
  1747.    DAYO Smart Reports,     TJS LAB                                   Page: 34
  1748.  
  1749.  
  1750.  
  1751.  ■ GL POSTING PROBLEMS
  1752.  
  1753.       This report checks databases for 'Bad' CLASS Codes that will cause a
  1754.   problem at time of GL Posting.
  1755.  
  1756.       You have the option to run it against all databases or to select
  1757.   specific databases.
  1758.  
  1759.  
  1760.  
  1761.  ■ EXAMPLE OF GL POSTING PROBLEMS REPORT
  1762.  
  1763.  
  1764.  Page No.     1
  1765.  09/07/90
  1766.                        GENERAL LEDGER PRE-POST CLASS CODE
  1767.                                  PROBLEM REPORT
  1768.                                 DATABASE: INV.DBF
  1769.  
  1770.                                                    *****
  1771.                                                    CLASS             Extended
  1772.  Item         Vendor     Description               CODE  Date     Cost*Onhand
  1773.  ------------ ---------- ------------------------- ***** -------- -----------
  1774.  
  1775.  AC2320       ACSCOMMERI CHILDREN'S STRAWBERRY SAN SH    08/27/90        0.00
  1776.  AC3011       ACSCOMMERC 2-LEAF LADIES SLIPPERS    SH    08/11/90        0.00
  1777.  AC3011C      ACSCOM     2-LEAF CHILD SLIPPERS     SH      /  /          0.00
  1778.  AC3019       ACSCOM     DOUBLE BOWTIE LADIES SLIP SH      /  /          0.00
  1779.  AC3111       ACSCOMMERC 2-LEAF LADIES SLIPPERS    SH    08/11/90        0.00
  1780.  AC3211       ACSCOMMERC 2-LEAF LADIES SLIPPERS    SH    08/11/90        0.00
  1781.  AC3311       ACSCOMMERC 2-LEAF LADIES SLIPPERS    SH    08/11/90        0.00
  1782.  AC3411       ACSCOMMERC 2-LEAF LADIES SLIPPERS    SH    08/11/90        0.00
  1783.  AC3511       ACSCOMMERC 2-LEAF LADIES SLIPPERS    SH    08/11/90        0.00
  1784.  AC3611       ACSCOMMERC 2-LEAF LADIES SLIPPERS    SH    08/11/90        0.00
  1785.  AC3711       ACSCOMMERC 2-LEAF LADIES SLIPPERS    SH    08/11/90        0.00
  1786.  
  1787.    DAYO Smart Reports,     TJS LAB                                   Page: 35
  1788.  
  1789.  
  1790.  
  1791.  ■ TAX SUMMARIES
  1792.  
  1793.       For tax reporting purposes, it is often required to summarize taxes
  1794.   paid to states, and in some cases to counties. By using the TAXCODE field
  1795.   in the customer's record, you can summarize taxes by unique TAXCODEs.
  1796.  
  1797.       This is a two part report.
  1798.  
  1799.       The first part summarizes by Ship To state, ie:
  1800.  
  1801.  
  1802.         Page No.     1       Period: 01/08/90 to 09/08/90
  1803.         09/08/90
  1804.                                     DAYO TAX REPORT
  1805.                                    SUBTOTAL BY STATE
  1806.  
  1807.              Taxes
  1808.         ----------
  1809.  
  1810.         ** State Code: FL
  1811.         ** Subtotal **
  1812.           20003.12
  1813.  
  1814.         ** State Code: CA
  1815.         ** Subtotal **
  1816.              20.00
  1817.  
  1818.         ** State Code: SC
  1819.         ** Subtotal **
  1820.              10.20
  1821.         *** Total ***
  1822.           20033.32
  1823.  
  1824.  
  1825.       The second part summarizes by TAXCODE, ie:
  1826.  
  1827.  
  1828.     TAX SUMMARY BY TAX CODE       Date: 09/04/90
  1829.     Period: 08/01/90 to 08/31/90
  1830.     Code       Amount
  1831.     ----   ----------
  1832.     CX1         10.12
  1833.     CX2         10.00
  1834.     CX3         10.00
  1835.     CX4         10.00
  1836.     CX5         10.10
  1837.     CX6         10.10
  1838.     CXA         10.10
  1839.            ----------
  1840.                 70.42
  1841.    DAYO Smart Reports,     TJS LAB                                   Page: 36
  1842.  
  1843.  
  1844.  
  1845.  ■ MASTER INVENTORY
  1846.  
  1847.       This routine compares two DAYO inventory databases, updating one from the
  1848.   the other. One database (the Master/Main Inventory) is used to update
  1849.   another.
  1850.  
  1851.       Produces a report of changes & additions.
  1852.  
  1853.       A special feature of this report is that you can select an option to
  1854.   return to DOS immediately after running the report.
  1855.  
  1856.  
  1857.  
  1858.  ■ EXAMPLE OF THE MASTER INVENTORY UPDATE REPORT
  1859.  
  1860.  
  1861.  MASTER INVENTORY UPDATE  -  ADDITIONS & CHANGES
  1862.  Date: 09/08/90   Time: 00:04:57                                    Page  1
  1863.  Run by: SDF                               Site: SAL'S THINGS
  1864.  ITEM         DESCRIPTION                    MESSAGE
  1865.  ------------ ------------------------------ ----------
  1866.  EV044K5      EVEREST BELLY BAG 5-POCKET     Change
  1867.   Field: CLASS Was: BB Now: CCC
  1868.  
  1869.  SH509        PALADINO NYLON 3-PKT BELLY BAG Change
  1870.   Field: WEIGHT Was:     0.00 Now:    23.00
  1871.  
  1872.  SH709FLA     FLORIDA SUPER 5-PKT BELLY BAG  Change
  1873.   Field: SERIALNO Was: .F. Now: .T.
  1874.  
  1875.  
  1876.  
  1877.  
  1878.  MASTER INVENTORY UPDATE  -  ITEMS NOT IN MASTER INVENTORY  * * *
  1879.  Date: 09/08/90   Time: 00:05:01                                    Page  1
  1880.  Run by: SDF     Site: SAL'S THINGS
  1881.  ITEM         DESCRIPTION                       ONHAND   SOLDYTD DATE
  1882.  ------------ ------------------------------ --------- --------- --------
  1883.  AC2320       CHILDREN'S STRAWBERRY SANDAL       0.000     0.000 08/27/90
  1884.  AC3011       2-LEAF LADIES SLIPPERS             0.000     0.000 08/11/90
  1885.  AC3011C      2-LEAF CHILD SLIPPERS              0.000     0.000   /  /
  1886.  AC3019       DOUBLE BOWTIE LADIES SLIPPERS      0.000     0.000   /  /
  1887.  AC3211       MEN/LADIES NEON BEACHCOMBERS       0.000     0.000   /  /
  1888.  AC3666       SINGLE BOWTIE LADIES SLIPPERS      0.000     0.000   /  /
  1889.  AC3734       LADIES ELASTIC SANDAL              0.000     0.000 08/28/90
  1890.  AC5201       MEN/LADIES BEACHCOMBERS            0.000     0.000   /  /
  1891.    DAYO Smart Reports,     TJS LAB                                   Page: 37
  1892.  
  1893.  
  1894.  
  1895.  ■ NON-TAXABLE SALES
  1896.  
  1897.  
  1898.       This routine will print all taxable or non-taxable AR Header records.
  1899.   This enables you to break down your sales by tax type. The report also has
  1900.   the option of printing just a one line summary.
  1901.  
  1902.       The expanded report contains the following fields:
  1903.  
  1904.          INVOICE, CUSTOMER, TYPE, TERMS, SALESREP, CLASS, TAXRATE, TAXES,
  1905.  
  1906.          FREIGHT, ADJUST, SUBTOTAL, PAID, BALANCE, & DATE
  1907.  
  1908.       The summary and expanded report contains subtotals for the following
  1909.   fields:
  1910.  
  1911.          TAXES, FREIGHT, ADJUST, SUBTOTAL, PAID, & BALANCE
  1912.  
  1913.  
  1914.  
  1915.            ╔═══════════════════════════════════════════════════════╗
  1916.            ║This report will print all your taxable or             ║
  1917.            ║non-taxable posted invoice headers (database ARH.DBF)  ║
  1918.            ║or a summary for a selected date range.                ║
  1919.            ║Uses Report Form TAXABLES.FRM  (132 Character Wide)    ║
  1920.            ║                                                       ║
  1921.            ║Start Date:  08/09/90   Ending Date:  09/08/90         ║
  1922.            ║                                                       ║
  1923.            ║Report Non-Taxable Only?  (Y/N)  (No: Taxable Only)    ║
  1924.            ║                                                       ║
  1925.            ║Will this be a Summary Only?  (Y/N)                    ║
  1926.            ║                                                       ║
  1927.            ║Select Index -> INVOICE NUMBER                         ║
  1928.            ║                                                       ║
  1929.            ║Send Output to Printer? (Y/N)       ( No -> To File)   ║
  1930.            ║                                                       ║
  1931.            ║Enter File Name:  TAX_N_X.TXT                          ║
  1932.            ║                                                       ║
  1933.            ║                                                       ║
  1934.            ╚═══════════════════════════════════════════════════════╝
  1935.  
  1936.    DAYO Smart Reports,     TJS LAB                                   Page: 38
  1937.  
  1938.  
  1939.  ■ BIG LABELS
  1940.  
  1941.       This report option was added to allow you to print any size address
  1942.   labels (ie: 4" X 4") for customer, shiptos, and vendors.
  1943.  
  1944.  
  1945.  DAYORPT V2.0, TJS LAB                                   ┌──[September 1990]──┐
  1946.       ██▄████░   ████░  ▄██████░       │■│┌───────────────────────────────┐│■│
  1947.       ██░  ██░    ██░   ██░            │■││       Your Company Name       ││■│
  1948.       ██░  ██░    ██░   ██░            │■││      12345 Orange Street      ││■│
  1949.       ██████░     ██░   ██░  ███░      │■││         Suite 100A            ││■│
  1950.       ██░  ██░    ██░   ██░   ██░      │■││    Anyplace, ST 12345-1234    ││■│
  1951.       ██░  ██░    ██░   ██░   ██░      │■│├───────────────────────────────┤│■│
  1952.       ██▀████░   ████░  ▀██████▀       │■││   Customer, ShipTo, Vendor    ││■│
  1953.                                        │■││      Address Line Here        ││■│
  1954.    █░    ▄█▄   █▄██░ ███░ █░   ▄██▄    │■││    Another Address Line       ││■│
  1955.    █░    █░█░  █░ █░ █░   █░   █░      │■││      City, State, ZIP         ││■│
  1956.    █░    █▄█░  █▄▄█░ ██░  █░   █▄▄▄    │■│└───────────────────────────────┘│■│
  1957.    █░   █▀ ▀█░ █░ █░ █░   █░      █░   │■│┌───────────────────────────────┐│■│
  1958.    ███░ █░  █░ █▀██░ ███░ ███░ ▀██▀    │■││       Your Company Name       ││■│
  1959.  ╔════════════════════════════════════════════════════════════════════════════╗
  1960.  ║Select Label Option -> Customer Bill To                                     ║
  1961.  ║                       Customer Ship To #1                                  ║
  1962.  ║                       Customer Ship To #2                                  ║
  1963.  ║                       Vendor Bill To                                       ║
  1964.  ║                       Vendor Ship To                                       ║
  1965.  ║                       Label Configuration                                  ║
  1966.  ║                       Line Feed                                            ║
  1967.  ║                       Exit                                                 ║
  1968.  ╚════════════════════════════════════════════════════════════════════════════╝
  1969.  Esc (Exit)
  1970.  
  1971.  
  1972.  
  1973.  ■ BIG LABELS CONFIGURATION
  1974.  
  1975.       A default label configuration is shown in the following diagram, but you
  1976.   can change it to fix another label...
  1977.  
  1978.     ╔════════════════════════════════════════════════════════════════════╗
  1979.     ║    Print Your Company Name & Address:  Y                           ║
  1980.     ║           Print ATTN (Contact) Field:  Y                           ║
  1981.     ║            Number of Lines per Label:  18                          ║
  1982.     ║          Label Width (for centering):  40                          ║
  1983.     ║                      Starting Column:   0                          ║
  1984.     ║       Starting Line For Your Address:   5                          ║
  1985.     ║          Starting Line For Addressee:  12                          ║
  1986.     ║                                                                    ║
  1987.     ║    Print Sample?  (Y/N)                                            ║
  1988.     ║                                                                    ║
  1989.     ║    Exit?  (Y/N)                                                    ║
  1990.     ╚════════════════════════════════════════════════════════════════════╝
  1991.    DAYO Smart Reports,     TJS LAB                                 Page: 38.1
  1992.  
  1993.  
  1994.  
  1995.  ■ CUSTOMER EXPANDED
  1996.  
  1997.       This report is a modified version of the expanded customer report found
  1998.   in DAYO AR Reports menu. This one has more options.
  1999.  
  2000.             ╔═[ Customer Expanded ]══════════════════════════════╗
  2001.             ║ Customer Expanded Report with Ship To Data.        ║
  2002.             ║ Multiple Indexes.                                  ║
  2003.             ║ Not a Report Form.                                 ║
  2004.             ║                                                    ║
  2005.             ║                                                    ║
  2006.             ╚════════════════════════════════════════════════════╝
  2007.  
  2008.  
  2009.       This report has 10 indexes to chose from:
  2010.  
  2011.            ╔═══════════════════════════════════════════════════════╗
  2012.            ║The Customer Expanded Report contains as much data     ║
  2013.            ║for each customer that can fit onto a 132 character    ║
  2014.            ║wide printout. * Includes Ship To Information also.    ║
  2015.            ║                                                       ║
  2016.            ║Not a Report Form.                                     ║
  2017.            ║                                                       ║
  2018.            ║Select the Index -> CUSTOMER                           ║
  2019.            ║                    BILL TO NAME                       ║
  2020.            ║                    SHIP TO NAME                       ║
  2021.            ║                    LAST 4 DIGITS PHONE                ║
  2022.            ║                    BILL TO ZIP CODE                   ║
  2023.            ║                    ATTENTION/CONTACT                  ║
  2024.            ║                    BILL TO CITY                       ║
  2025.            ║                    SHIP TO ZIP CODE                   ║
  2026.            ║                    SALES PERSON CODE                  ║
  2027.            ║                    FAX PHONE NUMBER                   ║
  2028.            ║                                                       ║
  2029.            ║                                                       ║
  2030.            ╚═══════════════════════════════════════════════════════╝
  2031.  
  2032.       Most of the index options/selections require a temporary index:
  2033.  
  2034.          ┌──────────────────────────────────────────────────────────┐
  2035.          │      Database Name: \DAYOAR\CUSTOMER.DBF                 │
  2036.          │         Index Name: TEMPNTX7.NTX                         │
  2037.          │  Number of Records: 302                                  │
  2038.          │  ┌──────────────────────────────────────────────────┐    │
  2039.          │  │████████████                                      │    │
  2040.          │  └──────────────────────────────────────────────────┘    │
  2041.          │  0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 %  │
  2042.          └──────────────────────────────────────────────────────────┘
  2043.    DAYO Smart Reports,     TJS LAB                                 Page: 38.2
  2044.  
  2045.  
  2046.  
  2047.  ■ AP ADJUSTMENTS
  2048.  
  2049.       This report prints all Accounts Payable (AP) records that appear to be
  2050.   adjustments. AP adjustments have the following phrase in the COMMENT field:
  2051.  
  2052.                          ***GL PAYABLES ADJUSTMENT***
  2053.  
  2054.             ╔═[ AP Adjustments ]═════════════════════════════════╗
  2055.             ║                                                    ║
  2056.             ║ Accounts Payable Adjustments.                      ║
  2057.             ║ Multiple Indexes.                                  ║
  2058.             ║ Not a Report Form.                                 ║
  2059.             ║                                                    ║
  2060.             ║                                                    ║
  2061.             ╚════════════════════════════════════════════════════╝
  2062.  
  2063.       After passing through all the prompts/options for this report, an
  2064.   'exploding box' progress graph is displayed onto the screen.
  2065.  
  2066.  ╔══════════════════════════════════════════════════════┌────────────────────┐
  2067.  ║The Accounts Payable Adjustments Report will list     │┌──────────────────┐│
  2068.  ║AP Header records that were created as a result of    ││┌────────────────┐││
  2069.  ║making adjustments to one or more of the following    │││┌──────────────┐│││
  2070.  ║fields: SUBTOTAL, FREIGHT, ADJUST, TAXES, PAID        ││││┌────────────┐││││
  2071.  ║List all Detail for the payable also.                 │││││┌──────────┐│││││
  2072.  ║Date ranges supported.  Not a Report Form (131 WIDE). ││││││┌────────┐││││││
  2073.  ║                                                      │││││││┌──────┐│││││││
  2074.  ║Start Date:  12/01/89 End Date:  11/26/90             ││││││││┌────┐││││││││
  2075.  ║                                                      │││││││││┌──┐│││││││││
  2076.  ║Select the Index -> PO NUMBER                         ││││││││││90││││││││││
  2077.  ║                                                      │││││││││└──┘│││││││││
  2078.  ║Enter Number of Lines Per Page:    56                 ││││││││└────┘││││││││
  2079.  ║                                                      │││││││└──────┘│││││││
  2080.  ║Send Output to Printer? (Y/N)                         ││││││└────────┘││││││
  2081.  ║                         ( No -> To File)             │││││└──────────┘│││││
  2082.  ║Enter File Name:  APADJ.TXT                           ││││└────────────┘││││
  2083.  ║                                                      │││└──────────────┘│││
  2084.  ║TLJ            16 100012 S AF;LSDKFJAS;DFAS           ││└────────────────┘││
  2085.  ╚══════════════════════════════════════════════════════│└──────────────────┘│
  2086.                                                         └────────────────────┘
  2087.  
  2088.  ■ BATCH INVENTORY ADJUSTMENTS
  2089.  
  2090.       This is not a report. This routine provides a means of making batch
  2091.   adjustments to the inventory (INV.DBF) quantity (ONHAND).
  2092.  
  2093.             ╔═[ Batch Inventory Adj ]════════════════════════════╗
  2094.             ║                                                    ║
  2095.             ║ Batch Inventory Adjustments.                       ║
  2096.             ║ Routine to make inventory adjustments easier.      ║
  2097.             ║ No report generated with this routine.             ║
  2098.             ║                                                    ║
  2099.             ║                                                    ║
  2100.             ╚════════════════════════════════════════════════════╝
  2101.    DAYO Smart Reports,     TJS LAB                                 Page: 38.3
  2102.  
  2103.  
  2104.  
  2105.  ■ AR ADJUSTMENTS
  2106.  
  2107.  
  2108.       This report prints all Accounts Receivable Header records that have
  2109.   been closed (OPEN=.T.), and the amount collected does not equal the amount
  2110.   charged. The most common occurance for this is when the customer pays only
  2111.   a portion of an invoice, or receives some kind of discount from you.
  2112.  
  2113.  
  2114.             ╔═[ AR Adjustments ]═════════════════════════════════╗
  2115.             ║                                                    ║
  2116.             ║ AR Adjustments.                                    ║
  2117.             ║ Reports all Closed (OPEN=.F.) AR Invoices where    ║
  2118.             ║   PAID <> SUBTOTAL + ADJUST + FREIGHT + TAXES      ║
  2119.             ║                                                    ║
  2120.             ║                                                    ║
  2121.             ╚════════════════════════════════════════════════════╝
  2122.  
  2123.  
  2124.            ╔═══════════════════════════════════════════════════════╗
  2125.            ║The AR Adjustments Report prints all AR Header records ║
  2126.            ║that have been closed (OPEN=.F.), and the PAID field   ║
  2127.            ║(amount received from the customer) does not equal the ║
  2128.            ║sum of SUBTOTAL+ADJUST+TAXES+FREIGHT.                  ║
  2129.            ║Uses Report Form: ARADJ.FRM.                           ║
  2130.            ║                                                       ║
  2131.            ║Is this for ALL Customers?  (Y/N)                      ║
  2132.            ║No -> Specific Customer                                ║
  2133.            ║Start Date:  11/28/80   Ending Date:  11/26/90         ║
  2134.            ║                                                       ║
  2135.            ║Select Index -> INVOICE NUMBER                         ║
  2136.            ║                                                       ║
  2137.            ║Send Output to Printer? (Y/N)       ( No -> To File)   ║
  2138.            ║                                                       ║
  2139.            ║Enter File Name:  ARADJ.TXT                            ║
  2140.            ║                                                       ║
  2141.            ║                                                       ║
  2142.            ╚═══════════════════════════════════════════════════════╝
  2143.    DAYO Smart Reports,     TJS LAB                                 Page: 38.4
  2144.  
  2145.  
  2146.  
  2147.  
  2148.  ■ SPECIAL SALES REPORT I
  2149.  
  2150.       This is the first of a 3 part set of sales reports. This one prints
  2151.  sales data for a specific customer, sales person, class code, state,
  2152.  ship state, zip, ship zip, shipper, or taxcode. The following information is
  2153.  printed onto the report:
  2154.  
  2155.       INVOICE NUMBER
  2156.       CUSTOMER NUMBER
  2157.       CUSTOMER PO
  2158.       SALES PERSON (REP)
  2159.       INVOICE TYPE
  2160.       CLASS
  2161.       TERMS
  2162.       SHIPPER
  2163.       ADJUSTMENT & FREIGHT TOTAL
  2164.       SUBTOTAL
  2165.       AMOUNT PAID
  2166.       DATE OF INVOICE
  2167.  
  2168.  
  2169.             ╔═[ Special Sales Report I ]═════════════════════════╗
  2170.             ║                                                    ║
  2171.             ║ Special Sales Report #1.                           ║
  2172.             ║ Reports all sales (Header Info) for a specific     ║
  2173.             ║ CUSTOMER, SALES PERSON, CLASS CODE, STATE,         ║
  2174.             ║ SHIPSTATE, ZIP, SHIPZIP, SHIPPER, or TAXCODE.      ║
  2175.             ║                                                    ║
  2176.             ╚════════════════════════════════════════════════════╝
  2177.  
  2178.  
  2179.       Many index options are available, but most require the creation of a
  2180.   temporary index:
  2181.  
  2182.            ╔═══════════════════════════════════════════════════════╗
  2183.            ║Special Sales Report #1.                               ║
  2184.            ║Reports all sales (Header Info) for a specific         ║
  2185.            ║CUSTOMER, SALES PERSON, CLASS CODE, STATE,             ║
  2186.            ║SHIPSTATE, ZIP, SHIPZIP, SHIPPER, or TAXCODE.          ║
  2187.            ║Uses Report Forms: SALES1.FRM to SALES9.FRM.           ║
  2188.            ║                                                       ║
  2189.            ║Select Option -> CUSTOMER                              ║
  2190.            ║                 SALES PERSON CODE * Requires Indexing ║
  2191.            ║                 CLASS CODE        * Requires Indexing ║
  2192.            ║                 BILL TO STATE     * Requires Indexing ║
  2193.            ║                 SHIP TO STATE     * Requires Indexing ║
  2194.            ║                 BILL TO ZIP CODE  * Requires Indexing ║
  2195.            ║                 SHIP TO ZIP CODE  * Requires Indexing ║
  2196.            ║                 SHIPPER CODE      * Requires Indexing ║
  2197.            ║                 TAX CODE          * Requires Indexing ║
  2198.            ║                                                       ║
  2199.            ║                                                       ║
  2200.            ╚═══════════════════════════════════════════════════════╝
  2201.    DAYO Smart Reports,     TJS LAB                                 Page: 38.5
  2202.  
  2203.  
  2204.  
  2205.       Current Data can also be printed is defined as the range between the
  2206.   Start Date and the End Date:
  2207.  
  2208.            ╔═══════════════════════════════════════════════════════╗
  2209.            ║Special Sales Report #1.                               ║
  2210.            ║Reports all sales (Header Info) for a specific         ║
  2211.            ║CUSTOMER, SALES PERSON, CLASS CODE, STATE,             ║
  2212.            ║SHIPSTATE, ZIP, SHIPZIP, SHIPPER, or TAXCODE.          ║
  2213.            ║Uses Report Forms: SALES1.FRM to SALES9.FRM.           ║
  2214.            ║                                                       ║
  2215.            ║Select Option -> SALES PERSON CODE * Requires Indexing ║
  2216.            ║                                                       ║
  2217.            ║Enter Sales Person Code:                               ║
  2218.            ║                                                       ║
  2219.            ║Start Date:  11/28/80   Ending Date:  11/26/90         ║
  2220.            ║                                                       ║
  2221.            ║Send Output to Printer? (Y/N)       ( No -> To File)   ║
  2222.            ║                                                       ║
  2223.            ║Enter File Name:  SALES1.TXT                           ║
  2224.            ║                                                       ║
  2225.            ║Enter Report Title:  ACME PARTS SUPPLY, INC.           ║
  2226.            ║                                                       ║
  2227.            ║                                                       ║
  2228.            ╚═══════════════════════════════════════════════════════╝
  2229.  
  2230.  
  2231.  
  2232.  ■ SPECIAL SALES REPORT II
  2233.  
  2234.  
  2235.       This report prints similiar data to the 1st sales report, but with more
  2236.   emphasis on summaries of sales. The following information is reported:
  2237.  
  2238.       CUSTOMER NUMBER
  2239.       CUSTOMER NAME
  2240.       SALES PERSON (REP)
  2241.       CLASS
  2242.       PTD SALES
  2243.       PTD PROFIT
  2244.       PTD MARGIN
  2245.       YTD SALES
  2246.       YTD PROFIT
  2247.       YTD MARGIN
  2248.       CURRENT SALES
  2249.       CURRENT PROFIT
  2250.       CURRENT MARGIN
  2251.       GROWTH RATE
  2252.  
  2253.       *** The Growth Rate is a number between 1 and -1. It depicts the Profit
  2254.   Trend for each customer and the report as a whole. A Growth Rate of around 0
  2255.   means that profits for a customer are constant. A negative Growth Rate shows
  2256.   a decrease in profits for a customer. A positive Growth Rate shows an
  2257.   increase in profits for a customer.
  2258.    DAYO Smart Reports,     TJS LAB                                 Page: 38.6
  2259.  
  2260.  
  2261.  
  2262.             ╔═[ Special Sales Report II ]════════════════════════╗
  2263.             ║                                                    ║
  2264.             ║ Special Sales Report #2. Similiar to #1, but       ║
  2265.             ║ computes data from the AR detail records           ║
  2266.             ║ instead of the header records. Includes PTD, YTD   ║
  2267.             ║ and Last Year sales/profit/margin information.     ║
  2268.             ║                                                    ║
  2269.             ╚════════════════════════════════════════════════════╝
  2270.  
  2271.  
  2272.       A more elaborate date reporting system is defined in this report. The
  2273.   user is prompted to enter the beginning and ending dates of last year,
  2274.   current year and current period:
  2275.  
  2276.  ╔════════════════════════════[ SALES REPORT #2 ]═════════════════════════════╗
  2277.  ║Special Sales Report #2.                                                    ║
  2278.  ║Reports sales totals for a specific CUSTOMER, SALES PERSON,                 ║
  2279.  ║CLASS, STATE, SHIPSTATE, ZIP, SHIPZIP, SHIPPER, TAXCODE or ITEM.            ║
  2280.  ║Not a Report Form (150 characters wide!)...                                 ║
  2281.  ║Select Option -> CLASS CODE        * Requires Indexing                      ║
  2282.  ║                                                                            ║
  2283.  ║   Start of Last Year:  11/06/88     End of Last Year:  11/06/89            ║
  2284.  ║Start of Current Year:  11/07/89  End of Current Year:  11/06/90            ║
  2285.  ║      Start of Period:  10/01/90        End of Period:  10/31/90            ║
  2286.  ║                                                                            ║
  2287.  ║                                                                            ║
  2288.  ║                                                                            ║
  2289.  ║                                                                            ║
  2290.  ║                                                                            ║
  2291.  ║                                                                            ║
  2292.  ║                                                                            ║
  2293.  ║                                                                            ║
  2294.  ║                                                                            ║
  2295.  ║                                                                            ║ 
  2296.  ╚════════════════════════════════════════════════════════════════════════════╝ 
  2297.  Esc (Exit)
  2298.    DAYO Smart Reports,     TJS LAB                                 Page: 38.7
  2299.  
  2300.  
  2301.  
  2302.       A progress graph is displayed to the right of the screen:
  2303.  
  2304.  ╔════════════════════════════[ SALES REPORT #2 ]═════════════════════▄▄▄▄▄▄▄▄▄
  2305.  ║Special Sales Report #2.                                            ║100%┬──╫
  2306.  ║Reports sales totals for a specific CUSTOMER, SALES PERSON,         ║  . │──║
  2307.  ║CLASS, STATE, SHIPSTATE, ZIP, SHIPZIP, SHIPPER, TAXCODE or ITEM.    ║  . │──║
  2308.  ║Not a Report Form (150 characters wide!)...                         ║ 83%┼──╫
  2309.  ║Select Option -> CLASS CODE        * Requires Indexing              ║  . │──║
  2310.  ║                                                                    ║  . │──║
  2311.  ║   Start of Last Year:  11/06/88     End of Last Year:  11/06/89    ║ 67%┼──╫
  2312.  ║Start of Current Year:  11/07/89  End of Current Year:  11/06/90    ║  . │──║
  2313.  ║      Start of Period:  10/01/90        End of Period:  10/31/90    ║  . │──║
  2314.  ║Enter Growth Rate Range Factor:   8                                 ║ 50%┼──╫
  2315.  ║Send Output to Printer? (Y/N)       ( No -> To File)                ║  . │──║
  2316.  ║Enter File Name:  SALES2.TXT                                        ║  . │──║
  2317.  ║Enter Number of Lines Per Page:   50                                ║ 33%┼──╫
  2318.  ║Enter Report Title:  ACME SUPPLY COMPANY, INC.                      ║  . │──║
  2319.  ║                                                                    ║  . │──║
  2320.  ║Enter CLASS Code:  NC1                                              ║ 17%┼──╫
  2321.  ║                                                                    ║  . │██║
  2322.  ║                                                                    ║  . │██║
  2323.  ║                                                                    ║  0%┴██╫
  2324.  ╚════════════════════════════════════════════════════════════════════▀▀▀▀▀▀▀▀▀
  2325.  
  2326.  
  2327.  
  2328.  ■ SPECIAL SALES REPORT III
  2329.  
  2330.       This report is identical to the 2nd sales report except that it also
  2331.   prints all the detail items/records. Using this report, you can identify
  2332.   exactly what a customer/client has purchased. The additional item information
  2333.   that is reported is:
  2334.  
  2335.       INVOICE NUMBER
  2336.       ITEM
  2337.       DESCRIPTION
  2338.       QTY
  2339.       PRICE
  2340.       COST
  2341.       PROFIT
  2342.       MARGIN
  2343.       CLASS
  2344.  
  2345.  
  2346.             ╔═[ Special Sales Report III ]═══════════════════════╗
  2347.             ║                                                    ║
  2348.             ║ Special Sales Report #3. Same as #2, but also      ║
  2349.             ║ prints the detail records.                         ║
  2350.             ║                                                    ║
  2351.             ║                                                    ║
  2352.             ║                                                    ║
  2353.             ╚════════════════════════════════════════════════════╝
  2354.    DAYO Smart Reports,     TJS LAB                                 Page: 38.8
  2355.  
  2356.  
  2357.  
  2358.       You can specify whether you want to print the detail lines for just the
  2359.   current period, current year or for last year through current period:
  2360.  
  2361.  ╔════════════════════════════[ SALES REPORT #3 ]═════════════════════════════╗
  2362.  ║Special Sales Report #3.  Prints every Invoice Detail record!               ║
  2363.  ║Reports sales totals for a specific CUSTOMER, SALES PERSON,                 ║
  2364.  ║CLASS, STATE, SHIPSTATE, ZIP, SHIPZIP, SHIPPER, TAXCODE or ITEM.            ║
  2365.  ║Not a Report Form (150 characters wide!)...                                 ║
  2366.  ║Select Option -> CLASS CODE        * Requires Indexing                      ║
  2367.  ║                                                                            ║
  2368.  ║   Start of Last Year:  11/07/88     End of Last Year:  11/07/89            ║
  2369.  ║Start of Current Year:  11/08/89  End of Current Year:  12/31/90            ║
  2370.  ║      Start of Period:  10/01/90        End of Period:  12/31/90            ║
  2371.  ║Enter Growth Rate Range Factor:  12                                         ║
  2372.  ║Send Output to Printer? (Y/N)       ( No -> To File)                        ║
  2373.  ║Enter File Name:  SALES3.TXT                                                ║
  2374.  ║Enter Number of Lines Per Page:   50                                        ║
  2375.  ║Enter Report Title:  dlksjhflksjdfsd                                        ║
  2376.  ║Select Option -> Print Detail For Last Year Through Current Period          ║
  2377.  ║                 Print Detail For Current Year                              ║
  2378.  ║                 Print Detail For Current Period                            ║
  2379.  ║                                                                            ║
  2380.  ╚════════════════════════════════════════════════════════════════════════════╝
  2381.  
  2382.  
  2383.  
  2384.  ■ CUSTOMER LIST #2
  2385.  
  2386.       This report is similiar to Customer List #1, except that multiple SHIP TO
  2387.   information is also printed out.
  2388.  
  2389.             ╔═[ Customer List #2 ]═══════════════════════════════╗
  2390.             ║                                                    ║
  2391.             ║ Customer List #2 with Ship To Names.               ║
  2392.             ║ List the customer Bill To and Ship To names,       ║
  2393.             ║ and telephone numbers.                             ║
  2394.             ║                                                    ║
  2395.             ╚════════════════════════════════════════════════════╝
  2396.  
  2397.  
  2398.       Multiple index options are presented:
  2399.  
  2400.       Select the Index -> CUSTOMER
  2401.                           BILL TO NAME
  2402.                           SHIP TO NAME
  2403.                           LAST 4 DIGITS PHONE
  2404.                           BILL TO ZIP CODE
  2405.                           ATTENTION/CONTACT
  2406.                           BILL TO CITY
  2407.                           SHIP TO ZIP CODE
  2408.                           SALES PERSON CODE
  2409.    DAYO Smart Reports,     TJS LAB                                 Page: 38.9
  2410.  
  2411.  
  2412.       A progress graph depicting colored boxes is displayed onto the screen:
  2413.  
  2414.                ┌───┐┌───┐┌───┐┌───┐┌───┐┌───┐┌───┐┌───┐┌───┐┌───┐
  2415.                │10%││20%││30%││40%││50%││60%││70%││80%││90%││100│
  2416.                └───┘└───┘└───┘└───┘└───┘└───┘└───┘└───┘└───┘└───┘
  2417.  
  2418.  
  2419.  ■ EXAMPLE OF THE CUSTOMER LIST #2
  2420.  
  2421.                             ACME PARTS SUPPLY, INC.              Page: 1
  2422.                         Customer List #2 (with Ship Tos)         Date: 11/26/90
  2423.                     ^^ Default Ship To    ^ Multiple Ship To
  2424.  
  2425.  Customer  Name                            Phone
  2426.  --------  ------------------------------  --------------  --------------------
  2427.    2293    C & S Novelties                 237-5555
  2428.    2311    Rosedale Dataline
  2429.    2313    Sherman Designs                 (302) 558-5555
  2430.    2361    Software Support Customer
  2431.    2362    The Programmer's Shop           (637) 740-5555
  2432.    2413    New England Comics              (502) 583-5555
  2433.    2457    Gertrude A. Ford                546-6327
  2434.    2501    Roger Gay
  2435.    2595    Bradford Board of Education
  2436.    2624    SDN Project
  2437.    2643    GAF Tel-Com
  2438.    2644    Alan Harrison                   (803) 555-5555
  2439.    2757    Electric Indicator Co., Inc.    (803) 847-5555
  2440.    2766    Rothrist Tube, Inc.             (801) 670-4257
  2441.    2775    Assc For Retarded Citizens
  2442.    2780    Pinkstone & Marquez Inc.        (904) 869-0100
  2443.    2783    Atul Mitra                      (913) 469-2131
  2444.    28011   Larry Thompson                  (407) 291-6987
  2445.     2801^^ Larry Thompson #2               (407) 291-6987
  2446.      2801^ Larry Thompson #3 (Martin)      (407) 291-3960
  2447.      2801^ Larry Thompson #4               (407) 291-3960
  2448.      2801^ Larry Thompson #5 (Jose)        (407) 291-3960
  2449.      2801^ Larry Thompson #6 (Juan)        (407) 291-3960
  2450.      2801^ Larry Thompson #7 (Jesus)       (407) 291-3960
  2451.      2801^ Larry Thompson #8 (Mary)        (407) 291-3960
  2452.      2801^ Larry Thompson #9               (407) 291-3960
  2453.      2801^ Larry Thompson #10              (407) 291-3960
  2454.      2801^ Larry Thompson #11              (407) 291-3960
  2455.      2801^ Larry Thompson #12 (Sal)        (407) 291-3960
  2456.      2801^ Larry Thompson #13              (407) 291-3960
  2457.      2801^ Larry Thompson #14 (Joe)        (407) 291-3960
  2458.      2801^ Larry Thompson #15 (Debbie)     (407) 291-3960
  2459.    2919    Stereo Exchange, Inc.
  2460.    2922    James J. Spinelli               (804) 793-5555
  2461.    2931    Vitron Management Consult. Inc  (313) 793-5555
  2462.    2979    Remee Products
  2463.    2982    Home & City Savings Bank        (802) 479-5555
  2464.    3001    Computer Directions, Inc.       (213) 834-5555
  2465.    3023    Rick Guggemos
  2466.    3048    Carolina Color Corporation
  2467.    3317    Air Filter Service              (803) 555-9321
  2468.    DAYO Smart Reports,     TJS LAB                                 Page: 38.91
  2469.  
  2470.  
  2471.  
  2472.  ■ INSERT DECIMALS
  2473.  
  2474.       This is not a report. This routine globally modifies the structure for
  2475.   all quantity fields (ie: ONHAND, PTDSOLD, ORDERED, RECEIVED) in the following
  2476.   databases: INV.DBF, ALLOCATE.DBF, APD.DBF, ARD.DBF, BO.DBF, BOM.DBF,
  2477.   DETAIL.DBF, ENDITEMS.DBF, INVADJ.DBF, PHYINV.DBF, POD.DBF, QUOTESD.DBF,
  2478.   REC.DBF, TEMPLATE.DBF, and WAREHOUS.DBF.
  2479.  
  2480.  
  2481.             ╔═[ Insert Decimals ]════════════════════════════════╗
  2482.             ║                                                    ║
  2483.             ║ Insert Decimals into all databases with a          ║
  2484.             ║ quantity field, ie: ONHAND in inventory...         ║
  2485.             ║ This routine does not print anything!              ║
  2486.             ║                                                    ║
  2487.             ║                                                    ║
  2488.             ╚════════════════════════════════════════════════════╝
  2489.  
  2490.  
  2491.       The progress of the operation is scrolled onto the lower part of the
  2492.   screen:
  2493.  
  2494.  ╔════════════════════════════════[ DECIMALS ]════════════════════════════════╗
  2495.  ║This routine will insert decimals in the quantity/onhand fields in all      ║
  2496.  ║DAYO databases that have item quantity fields, ie: inventory, invoices,     ║
  2497.  ║purchase orders, MRP, backorders, quotes, receipts, ...                     ║
  2498.  ║Check the database location options in the Configuration Menu to insure     ║
  2499.  ║their accuracy.                                                             ║
  2500.  ║REQUIRES EXCLUSIVE USE OF THE DATABASES!    * DO A FULL BACKUP FIRST! *     ║
  2501.  ║IF ON A NETWORK, INSURE THAT NO ONE IS IN THE SYSTEM!                       ║
  2502.  ║USE WITH CAUTION!                                                           ║
  2503.  ║Decimals for the ONHAND field in the inventory is currently set to 2        ║
  2504.  ║Enter Number of Decimals:  2                                                ║
  2505.  ║                                                                            ║
  2506.  ║Are you sure you want to continue?  (Y/N)                                   ║
  2507.  ║                                                                            ║
  2508.  ║Last chance to abort!    Are you really sure?  (Y/N)                        ║
  2509.  ║           DATABASE       FIELD         TYPE   LENGTH   DECIMALS            ║
  2510.  ║           INV            BO            N          10          2            ║
  2511.  ║           INV            ONORDER       N          10          2            ║
  2512.  ║           INV            UNITQTY       N          10          2            ║
  2513.  ║           INV            ALLOCATED     N          10          2            ║
  2514.  ║           INV            SOLDPTD       N          10          2            ║
  2515.  ╚════════════════════════════════════════════════════════════════════════════╝
  2516.           *** Do Not Disturb Me While I Reconstruct The Databases! ***
  2517.    DAYO Smart Reports,     TJS LAB                                 Page: 38.92
  2518.  
  2519.  
  2520.  
  2521.  ■ WAREHOUSE REORDER
  2522.  
  2523.       This report does require a report form, and will automatically determine
  2524.   and report any number of warehouses. Note, the width of the report increases
  2525.   by 7 spaces for each additional warehouse. The report is 132 characters wide
  2526.   with 10 (3 more than the default of 7) warehouses.
  2527.  
  2528.             ╔═[ Warehouse Reorder ]══════════════════════════════╗
  2529.             ║                                                    ║
  2530.             ║ Warehouse Reorder Report.                          ║
  2531.             ║ Reports only the reorder quantity for warehouses   ║
  2532.             ║ and the main warehouse (ONHAND).                   ║
  2533.             ║                                                    ║
  2534.             ╚════════════════════════════════════════════════════╝
  2535.  
  2536.  
  2537.       You have the option of printing only those items that require some kind
  2538.   of reorder, or all:
  2539.  
  2540.             ╔══[ Warehouse Reorder ]═════════════════════════════╗
  2541.             ║■Print ONLY items requiring reorder?  (Y/N)         ║
  2542.             ║                                                    ║
  2543.             ║ Send Output to Printer? (Y/N)                      ║
  2544.             ║                          ( No -> To File)          ║
  2545.             ║ Enter File Name:  REWARE.TXT                       ║
  2546.             ╚════════════════════════════════════════════════════╝
  2547.  
  2548.  
  2549.       A progress graph is displayed on to screen:
  2550.  
  2551.                            ╔══════════════════════╗
  2552.                            ║   ┌──────────────┐   ║
  2553.                            ║   │              │   ║
  2554.                            ║   │              │   ║
  2555.                            ║   │██████████████│   ║
  2556.                            ║   │██████████████│   ║
  2557.                            ║   │██████████████│   ║
  2558.                            ║   └─────╖  ╓─────┘   ║
  2559.                            ║         ║██║         ║
  2560.                            ║         ║  ║         ║
  2561.                            ║   ┌─────╜██╙─────┐   ║
  2562.                            ║   │100%          │   ║
  2563.                            ║   │80%   ██      │   ║
  2564.                            ║   │60%           │   ║
  2565.                            ║   │██████████████│   ║
  2566.                            ║   │██████████████│   ║
  2567.                            ║  ╔╧══════════════╧╗  ║
  2568.                            ║  ║ PROGRESS GLASS ║  ║
  2569.                            ║ ═╩════════════════╩═ ║
  2570.                            ╚══════════════════════╝
  2571.    DAYO Smart Reports,     TJS LAB                                 Page: 38.93
  2572.  
  2573.  
  2574.  
  2575.  ■ SERIAL NUMBERS IN
  2576.  
  2577.       This report prints records from the database SERIALIN.DBF, found in the
  2578.   DAYO Inventory directory.  This report will print serial numbers that were
  2579.   recorded when the items were received into the inventory.
  2580.  
  2581.  
  2582.             ╔═[ Serial Numbers In ]══════════════════════════════╗
  2583.             ║                                                    ║
  2584.             ║ Serial Numbers In Report.                          ║
  2585.             ║ Reports records of serial numbers recorded at time ║
  2586.             ║ of receipt into the inventory.                     ║
  2587.             ║                                                    ║
  2588.             ║                                                    ║
  2589.             ╚════════════════════════════════════════════════════╝
  2590.  
  2591.  
  2592.       You can specify a 'range' of serial number records to print, or all:
  2593.  
  2594.       ╔═════════════════════════════════════════════════════════════════╗
  2595.       ║   This report will print serial numbers that were recorded      ║
  2596.       ║   when the items were received into the inventory.              ║
  2597.       ║                                                                 ║
  2598.       ║   Select Option -> Specific Purchase Order Number               ║
  2599.       ║                    Specific ITEM Number                         ║
  2600.       ║                    Specific CONTROL Number                      ║
  2601.       ║                    Specific VENDOR Number                       ║
  2602.       ║                    Specific Serial Number                       ║
  2603.       ║                    From/To Dates                                ║
  2604.       ║                    All                                          ║
  2605.       ║                                                                 ║
  2606.       ║                                                                 ║
  2607.       ║                                                                 ║
  2608.       ║                                                                 ║
  2609.       ║                                                                 ║
  2610.       ║                                                                 ║
  2611.       ║                                                                 ║
  2612.       ║                                                                 ║
  2613.       ╚═════════════════════════════════════════════════════════════════╝
  2614.       Esc (Exit)   F1 (Help)
  2615.  
  2616.    DAYO Smart Reports,     TJS LAB                                 Page: 38.94
  2617.  
  2618.  
  2619.  ■ EXAMPLE OF THE SERIAL NUMBER IN REPORT
  2620.  
  2621.   Page No.     1 Specific Control Number: ABC   Indexed on Control Number
  2622.   11/26/90
  2623.                                  SERIAL NUMBER IN
  2624.  
  2625.   SERIAL NUMBER   ITEM             PO    KEY CONTROL    VENDOR     DATE
  2626.   --------------- ------------ ------ ------ ---------- ---------- --------
  2627.   123A56-10775    286CPU-1        233 2931   TJ-3990    TJS LAB    03/02/90
  2628.   1234A6-10797    286CPU-1        323 2941   TJ-3990    TJS LAB    03/18/90
  2629.   1234D6-10343    286CPU-3        344 3121   TJ-3990    TJS LAB    03/13/90
  2630.   1234D6-14044    286CPU-1        383 3245   TJ-3990    TJS LAB    04/17/90
  2631.   1234F6-10425    286CPU-4        387 3323   TJ-3990    TJS LAB    06/04/90
  2632.   123436-10253    286CPU-1        394 3444   TJ-3990    TJS LAB    06/10/90
  2633.   123436-12342    286CPU-3        397 3534   TJ-3990    TJS LAB    08/31/90
  2634.   1234D6-103SG    286CPU-3        411 3604   TJ-3990    TJS LAB    09/02/90
  2635.   1234R6-10333    286CPU-3        433 3755   TJ-3990    TJS LAB    10/11/90
  2636.   123436-10222    286CPU-1        458 3800   TJ-3990    TJS LAB    11/21/90
  2637.  
  2638.  
  2639.  ■ SERIAL NUMBERS OUT
  2640.  
  2641.       This report will print serial numbers that were recorded when the items
  2642.   were invoiced using DAYO Point of Sale (POS).
  2643.  
  2644.             ╔═[ Serial Numbers Out ]═════════════════════════════╗
  2645.             ║                                                    ║
  2646.             ║ Serial Numbers Out Report.                         ║
  2647.             ║ Reports records of serial numbers recorded at time ║
  2648.             ║ of invoicing (in POS).                             ║
  2649.             ║                                                    ║
  2650.             ╚════════════════════════════════════════════════════╝
  2651.  
  2652.  
  2653.  ■ EXAMPLE OF THE SERIAL NUMBER OUT REPORT
  2654.  
  2655.         Page No.     4  Print All Records   Indexed on Serial Number
  2656.  
  2657.         11/26/90
  2658.                                 SERIAL NUMBERS OUT (POS)
  2659.  
  2660.  
  2661.         SERIAL NUMBER   ITEM         INVOICE CUSTOMER DATE
  2662.         --------------- ------------ ------- -------- --------
  2663.         12345-1292      PRINTER #3       205     6223 09/04/90
  2664.         A2 242-2 42     PRINTER #4       225     3002 10/11/90
  2665.         A2 3223-3 23
  2666.         A2 213-23 2
  2667.         TS-393          ALLL143          261     1100 11/13/90
  2668.         TS-38           ALLL143          259     2999 11/14/90
  2669.         TS-393          ALLL143          259     2999 11/16/90
  2670.         TS-89           ALLL143          259     2999 11/21/90
  2671.         TS-392A         ALLL143          259     2999 11/22/90
  2672.         TOM#9301        TOM TOM          244     4100 11/23/90
  2673.         12345-12345     AC2334           245     4340 11/26/90
  2674.    DAYO Smart Reports,     TJS LAB                                 Page: 38.95
  2675.  
  2676.  
  2677.  
  2678.  ■ BAD RECORDS
  2679.  
  2680.  
  2681.       This report was created to provide a means for users to find and fix Bad
  2682.   records. Bad records created when bad data is placed in one or more fields of
  2683.   a record. A leading cause of this is the rebooting of the machine while it
  2684.   is writing or updating a database.
  2685.  
  2686.  
  2687.             ╔═[ Bad Records ]════════════════════════════════════╗
  2688.             ║                                                    ║
  2689.             ║ Find & Fix Bad Records.                            ║
  2690.             ║ * Requires Exclusive Use of Databases *            ║
  2691.             ║ * Dangerous Operation - Backup First! *            ║
  2692.             ║                                                    ║
  2693.             ║                                                    ║
  2694.             ╚════════════════════════════════════════════════════╝
  2695.  
  2696.  
  2697.       The progress of this operation is displayed onto the screen:
  2698.  
  2699.  
  2700.  ╔════════════════════════════════════════════════════════════════════════════╗
  2701.  ║ Checking: \DAYOPOS\DETAIL.DBF                                              ║
  2702.  ╚════════════════════════════════════════════════════════════════════════════╝
  2703.  ╔════════════════════════════════════════════════════════════════════════════╗
  2704.  ║ ■ Standby while I check out: \DAYOPOS\DETAIL.DBF                           ║
  2705.  ║   Checking record:     597                                                 ║
  2706.  ╚════════════════════════════════════════════════════════════════════════════╝
  2707.    DAYO Smart Reports,     TJS LAB                                 Page: 38.96
  2708.  
  2709.  
  2710.  
  2711.  
  2712.  ■ RESET ALLOCATED
  2713.  
  2714.  
  2715.       This routine will reset the field 'ALLOCATED' in the inventory database
  2716.   (INV.DBF) to zero (0), then recompute the allocated quantity by counting up
  2717.   the number of items currently on open work orders (invoices not printed).
  2718.  
  2719.  
  2720.       The progress of the process is displayed onto the graph in the form
  2721.   of an hour glass.
  2722.  
  2723.  
  2724.  
  2725.   DAYORPT V2.0, TJS LAB                                  ┌───[January 1991]───┐
  2726.        ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄                                │S  M  T  W  T  F  S │
  2727.  ╔═════█┌──────────────┐█═╗  ████▄   ▄█▄  █░  █░ ▄███▄   ├────────────────────┤
  2728.  ║Inser█│              │█ ║  █░  █░  █░█░ █░  █░ █░  █░  │       1  2  3  4  5│
  2729.  ║Inser█│              │█ ║  █░  █░  █░█░ ▀█░██░ █░  █░  │ 6  7  8  9 10 11 12│
  2730.  ║Wareh█│██████████████│█ ║  █░  █░ █▀▀▀█░ ▀█▀   █░  █░  │13 14 15 16 17 18 19│
  2731.  ║Seria█│██████████████│█ ║  █░  █░ █░  █░  █░   █░  █░  │20 21 22 23 24 25 26│
  2732.  ║Seria█│██████████████│█ ║  ████▀  █░  █░  █░   ▀███▀   │27 28 29 30 31      │
  2733.  ║Bad R█└─────╖  ╓─────┘█ ║                              │                    │
  2734.  ║Reset▀▀▀▀▀▀█║  ║█▀▀▀▀▀▀ ║                              └────────────────────┘
  2735.  ║Reset▄▄▄▄▄▄█║  ║█▄▄▄▄▄▄ ╠═[ Reset Allocated ]═══════════════════════════════╗
  2736.  ║Set/R█┌─────╜  ╙─────┐█ ║                                                   ║
  2737.  ║Repor█│100%          │█ ║ Reset the ALLOCATED field in the inventory        ║
  2738.  ║Print█│80%           │█ ║ database (INV.DBF) based on open work orders      ║
  2739.  ║Misc █│60%           │█ ║ and back orders.                                  ║
  2740.  ╠═════█│██████████████│█═╣                                                   ║
  2741.  ║  Pre█│██████████████│█ ║                                                   ║
  2742.  ╚═════█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█═╩═══════════════════════════════════════════════════╝
  2743.     ▄███ PROGRESS GLASS █▄█▄  ███░       █▄█▄  ███░ █▄█▄  ▄█▄  █▄█▄  ███░ ▄██▄
  2744.     █░▄█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█▄ █░  █░        █░ █░ █░   █░ █░ █░█░ █░ █░  █░  █░
  2745.     █░    █░█░█░  █░█░  █▄▄█░  █░        █▄▄█░ ██░  █▄▄█░ █░█░ █▄▄█░  █░  █░
  2746.     ▀██▄  █░█░█░  █▄█░  █▀█░   █░        █▀█░  █░   █░    █░█░ █▀█░   █░  ▀██▄
  2747.        █░ █░▀ █░ █▀ ▀█░ █░█▄   █░        █░█▄  █░   █░    █░█░ █░█▄   █░     █░
  2748.     ▀██▀  █░  █░ █░  █░ █░ █░  █░        █░ █░ ███░ █░    ▀█▀  █░ █░  █░  ▀██▀
  2749.  Recomputing ALLOCATED from Work Orders...         Esc (Abort)
  2750.  
  2751.    DAYO Smart Reports,     TJS LAB                                 Page: 38.97
  2752.  
  2753.  
  2754.  
  2755.  ■ RESET BO - BACK ORDER QUANTITY
  2756.  
  2757.  
  2758.       This routine will reset the field 'BO' in the inventory database
  2759.   (INV.DBF) to zero (0), then recompute the BO quantity by counting up
  2760.   the number of items currently on open invoices in the Back Order database
  2761.   (BO.DBF).
  2762.  
  2763.  
  2764.       The progress of the process is displayed onto the graph in the form
  2765.   of an hour glass.
  2766.  
  2767.  
  2768.   DAYORPT V2.0, TJS LAB                                  ┌───[January 1991]───┐
  2769.        ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄                                │S  M  T  W  T  F  S │
  2770.  ╔═════█┌──────────────┐█═╗  ████▄   ▄█▄  █░  █░ ▄███▄   ├────────────────────┤
  2771.  ║Inser█│              │█ ║  █░  █░  █░█░ █░  █░ █░  █░  │       1  2  3  4  5│
  2772.  ║Inser█│              │█ ║  █░  █░  █░█░ ▀█░██░ █░  █░  │ 6  7  8  9 10 11 12│
  2773.  ║Wareh█│              │█ ║  █░  █░ █▀▀▀█░ ▀█▀   █░  █░  │13 14 15 16 17 18 19│
  2774.  ║Seria█│██████████████│█ ║  █░  █░ █░  █░  █░   █░  █░  │20 21 22 23 24 25 26│
  2775.  ║Seria█│██████████████│█ ║  ████▀  █░  █░  █░   ▀███▀   │27 28 29 30 31      │
  2776.  ║Bad R█└─────╖  ╓─────┘█ ║                              │                    │
  2777.  ║Reset▀▀▀▀▀▀█║  ║█▀▀▀▀▀▀ ║                              └────────────────────┘
  2778.  ║Reset▄▄▄▄▄▄█║  ║█▄▄▄▄▄▄ ╠═[ Reset BO ]══════════════════════════════════════╗
  2779.  ║Set/R█┌─────╜  ╙─────┐█ ║                                                   ║
  2780.  ║Repor█│100%          │█ ║ Reset the BO field in the inventory               ║
  2781.  ║Print█│80%           │█ ║ database (INV.DBF) based on the number of         ║
  2782.  ║Misc █│██████████████│█ ║ open back orders in database: BO.DBF.             ║
  2783.  ╠═════█│██████████████│█═╣                                                   ║
  2784.  ║  Pre█│██████████████│█ ║                                                   ║
  2785.  ╚═════█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█═╩═══════════════════════════════════════════════════╝
  2786.     ▄███ PROGRESS GLASS █▄█▄  ███░       █▄█▄  ███░ █▄█▄  ▄█▄  █▄█▄  ███░ ▄██▄
  2787.     █░▄█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█▄ █░  █░        █░ █░ █░   █░ █░ █░█░ █░ █░  █░  █░
  2788.     █░    █░█░█░  █░█░  █▄▄█░  █░        █▄▄█░ ██░  █▄▄█░ █░█░ █▄▄█░  █░  █░
  2789.     ▀██▄  █░█░█░  █▄█░  █▀█░   █░        █▀█░  █░   █░    █░█░ █▀█░   █░  ▀██▄
  2790.        █░ █░▀ █░ █▀ ▀█░ █░█▄   █░        █░█▄  █░   █░    █░█░ █░█▄   █░     █░
  2791.     ▀██▀  █░  █░ █░  █░ █░ █░  █░        █░ █░ ███░ █░    ▀█▀  █░ █░  █░  ▀██▀
  2792.  Resetting BO to Zero (0)...                    Esc (Abort)
  2793.    DAYO Smart Reports,     TJS LAB                                 Page: 38.98
  2794.  
  2795.  
  2796.  
  2797.  
  2798.  ■ SET MULTIPLE PRICE FIELDS IN INVENTORY
  2799.  
  2800.  
  2801.       Use this routine to determine and set the multiple price fields 'PRICE1
  2802.   to PRICE5' based on a List (Retail Price) discount or on a cost plus (Margin)
  2803.   method.
  2804.  
  2805.  
  2806.       Note, the 5 price fields must exist in the inventory database (INV.DBF),
  2807.   and if not, use the DAYO Update & Conversion program to place them there.
  2808.  
  2809.  
  2810.  
  2811.   ╔═════════════════[ SET MULTIPLE PRICE FIELDS IN INVENTORY ]════════════════╗
  2812.   ║                                                                           ║
  2813.   ║This routine will reset the mulitple price fields: PRICE1, PRICE2, PRICE3, ║
  2814.   ║PRICE4, PRICE5, based on a margin or list (RETAIL) discount method.        ║
  2815.   ║                                                                           ║
  2816.   ║                                                                           ║
  2817.   ║                              Field           (M)argin                     ║
  2818.   ║                              Name            (L)ist       Discount        ║
  2819.   ║                              PRICE1           M             50.000        ║
  2820.   ║                              PRICE2           M             40.000        ║
  2821.   ║                              PRICE3           M             30.000        ║
  2822.   ║                              PRICE4           M             20.000        ║
  2823.   ║                              PRICE5           M             10.000        ║
  2824.   ║                                                                           ║
  2825.   ║                                                                           ║
  2826.   ║                                                                           ║
  2827.   ║                                                                           ║
  2828.   ║                                                                           ║
  2829.   ║                                                                           ║
  2830.   ╚═══════════════════════════════════════════════════════════════════════════╝
  2831.  Esc (Exit)
  2832.    DAYO Smart Reports,     TJS LAB                                 Page: 38.99
  2833.  
  2834.  
  2835.  
  2836.  ■ MULTIPLE PRICING PROGRESS GRAPH
  2837.  
  2838.  
  2839.       The progress of the Multiple Price update is displayed onto the screen
  2840.   with an hour glass and a scroll of the items.
  2841.  
  2842.  
  2843.       ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
  2844.  ╔════█┌──────────────┐█ MULTIPLE PRICE FIELDS IN INVENTORY ]════════════════╗
  2845.  ║    █│              │█                                                     ║
  2846.  ║This█│              │█t the mulitple price fields: PRICE1, PRICE2, PRICE3, ║
  2847.  ║PRIC█│██████████████│█on a margin or list (RETAIL) discount method.        ║
  2848.  ║    █│██████████████│█                                                     ║
  2849.  ║    █│██████████████│█                                                     ║
  2850.  ║    █└─────╖  ╓─────┘█        Field           (M)argin                     ║
  2851.  ║    ▀▀▀▀▀▀█║  ║█▀▀▀▀▀▀        Name            (L)ist       Discount        ║
  2852.  ║    ▄▄▄▄▄▄█║  ║█▄▄▄▄▄▄        PRICE1           M             50.000        ║
  2853.  ║    █┌─────╜  ╙─────┐█        PRICE2           M             40.000        ║
  2854.  ║    █│100%          │█        PRICE3           M             30.000        ║
  2855.  ║    █│80%           │█        PRICE4           M             20.000        ║
  2856.  ║    █│60%           │█        PRICE5           M             10.000        ║
  2857.  ║    █│██████████████│█                                                     ║
  2858.  ║    █│██████████████│█           Item              PRICE1      PRICE5      ║
  2859.  ║    █▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█           APSBH-1            30.99       17.22      ║
  2860.  ║    █ PROGRESS GLASS █           YKEL245            28.92       16.07      ║
  2861.  ║   ▄█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█▄          YKEL145            26.86       14.92      ║
  2862.  ║                                 YK90086            24.79       13.77      ║
  2863.  ║                                 J234324            22.73       12.63      ║
  2864.  ║                                 I354534            20.66       11.48      ║
  2865.  ╚═══════════════════════════════════════════════════════════════════════════╝
  2866.  Esc (Exit)
  2867.    DAYO Smart Reports,     TJS LAB                                 Page: 39
  2868.  
  2869.  
  2870.  
  2871.  ■  MODIFY SCREEN COLORS
  2872.  
  2873.       This routine provides you with a means of modifying or altering any
  2874.   color combination in any of the DAYO modules.
  2875.  
  2876.       No Report is printed...
  2877.  
  2878.       This routine optionally creates a color file (database) in a DAYO
  2879.   module directory named COLORSET.DAT. When a DAYO module starts up, it looks
  2880.   for this file in its current directory, and if found uses the color settings
  2881.   in this file instead of the default colors. Erase it if you want to return
  2882.   to the default colors!
  2883.  
  2884.  
  2885.             ╔═[ Modify Screen Colors ]═══════════════════════════╗
  2886.             ║                                                    ║
  2887.             ║ Modify Screen Colors in Any DAYO Module.           ║
  2888.             ║ Use this routine to alter the colors in any        ║
  2889.             ║ DAYO Module.                                       ║
  2890.             ║                                                    ║
  2891.             ║                                                    ║
  2892.             ╚════════════════════════════════════════════════════╝
  2893.  
  2894.  
  2895.  
  2896.  ■  COLOR CHART
  2897.  
  2898.       The following is the initial screen for this option:
  2899.  
  2900.  ╔════════════════╦════════╦═══════════════════╦═════════════════════════════╗
  2901.  ║ Color          ║ Letter ║  Monochrome       ║ * Creates a blinking effect ║
  2902.  ╠════════════════╬════════╬═══════════════════╬═════════════════════════════╝
  2903.  ║ Black          ║   N    ║  Black            ║ ▄███░ ▄██▄  █░    ▄██▄  █▄██░
  2904.  ║ Blue           ║   B    ║  Underline        ║ █░    █░ █░ █░    █░ █░ █░ █░
  2905.  ║ Green          ║   G    ║  White            ║ █░    █░ █░ █░    █░ █░ ████░
  2906.  ║ Cyan           ║   BG   ║  White            ║ █░    █░ █░ █░    █░ █░ █░█░
  2907.  ║ Red            ║   R    ║  White            ║ ▀███░ ▀██▀  ████░ ▀██▀  █░██░
  2908.  ║ Magenta        ║   RB   ║  White            ║
  2909.  ║ Brown          ║   GR   ║  White            ║ █████░ █░   █▄██░ █░    ███░
  2910.  ║ White          ║   W    ║  White            ║   █░  █▀█░  █░ █░ █░    █░
  2911.  ║ Gray           ║   N+   ║  White            ║   █░  █░█░  █▀▀█░ █░    ██░
  2912.  ║ Bright Blue    ║   B+   ║  Bright Underline ║   █░ ██▄██░ █░ █░ █░    █░
  2913.  ║ Bright Green   ║   G+   ║  Bright White     ║   █░ █░  █░ █▀██░ ████░ ███░
  2914.  ║ Bright Cyan    ║   BG+  ║  Bright White     ║
  2915.  ║ Bright Red     ║   R+   ║  Bright White     ║  This routine allows you to
  2916.  ║ Bright Magenta ║   RB+  ║  Bright White     ║  modify/alter the screen
  2917.  ║ Yellow         ║   GR+  ║  Bright White     ║  colors for any DAYO module.
  2918.  ║ Bright White   ║   W+   ║  Bright White     ║  Read a dBase (tm) or Clipper
  2919.  ║ Black          ║   U    ║  Underline        ║  (tm) manual for more
  2920.  ║ Inverse Video  ║   I    ║  Inverse Video    ║  information on screen color
  2921.  ║ Blank          ║   X    ║  Blank            ║  codes...
  2922.  ╚════════════════╩════════╩═══════════════════╝
  2923.  Press any key to continue...
  2924.    DAYO Smart Reports,     TJS LAB                                 Page: 39.01
  2925.  
  2926.  
  2927.  
  2928.       Select the module you wish to install or modify colors in:
  2929.  
  2930.  
  2931.  ╔══════════════════════════[ MODIFY SCREEN COLORS ]══════════════════════════╗
  2932.  ║   Select Module -> DAYO Menu                                               ║
  2933.  ║       █▄██         Inventory, Purchasing, Receiving              █▄██      ║
  2934.  ║       █  █         POS, Point of Sale                            █  █      ║
  2935.  ║       █  █         Time & Billing                                █  █      ║
  2936.  ║       █▀██         AR, Accounts Receivable                       █▀██      ║
  2937.  ║                    AP, Accounts Payable                                    ║
  2938.  ║         █          GL, General Ledger                              █       ║
  2939.  ║        █▀█         Look Up DAYO Databases                         █▀█      ║
  2940.  ║       ██▄██        Payroll                                       ██▄██     ║
  2941.  ║       █   █        Quotes                                        █   █     ║
  2942.  ║                    Back Orders                                             ║
  2943.  ║       █   █        MRP, Materials Requirement Planning           █   █     ║
  2944.  ║       ▀█▄█▀        Price Books, Lists                            ▀█▄█▀     ║
  2945.  ║         █          Bar Codes                                       █       ║
  2946.  ║         █          Index                                           █       ║
  2947.  ║                    End of Period, Physical Inventory                       ║
  2948.  ║       ▄██▄         Smart Reports                                 ▄██▄      ║
  2949.  ║       █  █         Passwords                                     █  █      ║
  2950.  ║       █  █         Graphic Reports                               █  █      ║
  2951.  ║       ▀██▀         Sales Contacts                                ▀██▀      ║
  2952.  ║                                                                            ║
  2953.  ╚════════════════════════════════════════════════════════════════════════════╝
  2954.  Esc (Exit)   F1 (Help)   Enter/Return (Select)
  2955.  
  2956.  
  2957.       The following message is displayed onto the screen if colors are to
  2958.   modified for the first time in a particular module:
  2959.  
  2960.  
  2961.   ╔══════════════════════════════════════════════════════════════════════════╗
  2962.   ║  Color File Not Installed In: DAYO Menu                                  ║
  2963.   ║                                                                          ║
  2964.   ║  Install?  (Y/N)                                                         ║
  2965.   ╚══════════════════════════════════════════════════════════════════════════╝
  2966.  
  2967.  
  2968.       If you responded 'Y' Yes to the install prompt, you will then be prompted
  2969.   to enter the location of the selected DAYO module:
  2970.  
  2971.   ╔══════════════════════════════════════════════════════════════════════════╗
  2972.   ║  Color File Not Installed In: DAYO Menu                                  ║
  2973.   ║  (ie: C:\DAYOPOS\)                                                       ║
  2974.   ║  Enter Drive/Directory/Location:  \DAYO\                                 ║
  2975.   ╚══════════════════════════════════════════════════════════════════════════╝
  2976.    DAYO Smart Reports,     TJS LAB                                 Page: 39.02
  2977.  
  2978.  
  2979.       Finally, you will be presented with an edit screen of the 18 color code
  2980.   combinations:
  2981.  
  2982.  ╔══════════════════════════[ MODIFY SCREEN COLORS ]══════════════════════════╗
  2983.  ║                                                                            ║
  2984.  ║   #1                     Red:  R+/n,n/W,n/w,,n/w                 █▄██      ║
  2985.  ║   #2                   White:  W+/n,n/w,n/w,,n/w                 █  █      ║
  2986.  ║   #3            White on Red:  W+/R,n/w,n/w,,n/w                 █  █      ║
  2987.  ║   #4            Black on Red:  RG+/R,n/w,n/w,,n/w                █▀██      ║
  2988.  ║   #5           White on Blue:  W+/B,n/w,n/w,,n/w                           ║
  2989.  ║   #6   Blinking White on Red:  W+*/R,n/w,n/w,,n/w                  █       ║
  2990.  ║   #7  Blinking White on Blue:  W+*/B,n/w,n/w,,n/w                 █▀█      ║
  2991.  ║   #8                    Blue:  B+/n,n/w,n/w,,n/w                 ██▄██     ║
  2992.  ║   #9                    Cyan:  BG/N,n/w,n/w,,n/w                 █   █     ║
  2993.  ║   #10                  Green:  G/n,n/w,n/w,,n/w                            ║
  2994.  ║   #11                Magenta:  BR+/n,n/w,n/w,,n/w                █   █     ║
  2995.  ║   #12                 Yellow:  RG+/n,n/w,n/w,,n/w                ▀█▄█▀     ║
  2996.  ║   #13          Blinking Cyan:  BG/N,n/w,n/w,,n/w                   █       ║
  2997.  ║   #14           Blinking Red:  R+*/n,n/w,n/w,,n/w                  █       ║
  2998.  ║   #15         Blinking Green:  G+*/n,n/w,n/w,,n/w                          ║
  2999.  ║   #16         Blinking White:  W+*/n,n/w,n/w,,n/w                ▄██▄      ║
  3000.  ║   #17        Blinking Yellow:  RG+*/n,n/w,n/w,,n/w               █  █      ║
  3001.  ║   #18       Blinking Magenta:  BR+*/n,n/w,n/w,,n/w               █  █      ║
  3002.  ║                                                                  ▀██▀      ║
  3003.  ║                                                                            ║
  3004.  ╚════════════════════════════════════════════════════════════════════════════╝
  3005.   Esc (Exit)   F1 (Help)
  3006.  
  3007.  
  3008.       Colors Settings:  STANDARD,ENHANCED,BORDER
  3009.                         ie:  W+/N,N/W,W/N
  3010.  
  3011.       Standard       Main Screen Output
  3012.       Enhanced       Prompts and Selection Highlights
  3013.       Border         Border (Not on EGA & VGA Monitors...)
  3014.  
  3015.  
  3016.       Each of the above colors settings consists of 2 parts; the foreground and
  3017.       the background. The foreground and background is separated by a forward
  3018.       slash (/). The main colors are separated by a comma, ie:  W+/N,N/W,W/N
  3019.  
  3020.       Foreground color settings can also have high intensity or blinking
  3021.       attributes. Add a plus sign '+' for high intensity; an asterisk '*' for
  3022.       blinking.
  3023.  
  3024.                       High Intensity Example:   W+/N
  3025.  
  3026.                             Blinking Example:   W*/N
  3027.  
  3028.             Blinking, High Intensity Example:   W+*/N
  3029.    DAYO Smart Reports,     TJS LAB                                 Page: 39.03
  3030.  
  3031.  
  3032.  
  3033.  ■ ITEM TRACKER
  3034.  
  3035.       This is perhaps one of the 'smartest' Smart Reports. Use this report
  3036.   to tracking Item movement within your company for a selected date range.
  3037.   'Everything' about an Item is printed out from Inventory Adjustments
  3038.   (INVADJ.DBF), Receipts (REC.DBF) and Sales (ARD.DBF). The ONHAND quantity
  3039.   in the inventory database (INV.DBF), ONHAND quantity in the last inventory
  3040.   database (LASTINV.DBF) and the sum of the counted Items in the physical
  3041.   inventory is also printed. At the end of the report, the physical and
  3042.   last inventory databases are checked to see if they contain items not
  3043.   found in the inventory database.
  3044.  
  3045.       * Note, to insure proper sales reporting, be sure to perform the AR
  3046.   Post. This routine 'moves' closed/printed invoices into AR from DAYO POS.
  3047.  
  3048.  
  3049.             ╔═[ ITEM TRACKER ]═══════════════════════════════════╗
  3050.             ║                                                    ║
  3051.             ║ Complete Period Item Summary - ITEM TRACKER.       ║
  3052.             ║ Print out start/end inventory quantity, receipts,  ║
  3053.             ║ sales, and inventory adjustments (by item).        ║
  3054.             ║                                                    ║
  3055.             ║                                                    ║
  3056.             ╚════════════════════════════════════════════════════╝
  3057.  
  3058.       This report may take 'quite a while' to run due to the large number of
  3059.   files and records it has to go through...
  3060.  
  3061.  
  3062.  DAYO Smart Reports Version 2.0,  TJS LAB                ┌───[February 1991]──┐
  3063.  ╔══════════════════════════════[ ITEM TRACKER ]══════════════════════════════╗
  3064.  ║                                                                            ║
  3065.  ║ This report prints out the starting and ending quantities for every item   ║
  3066.  ║ (from your current and physical inventory), receipts, sales (from posted   ║
  3067.  ║ invoices in AR), Work in Process (from MRP) and inventory adjustments.     ║
  3068.  ║                                                                            ║
  3069.  ║ Use this report to track/determine 'variances' in the physical inventory.  ║
  3070.  ║                                                                            ║
  3071.  ║ This report may take 'quite a while' to run due to the large number of     ║
  3072.  ║ files and records it has to go through...                                  ║
  3073.  ║                                                                            ║
  3074.  ║   Enter Starting Date:  01/05/90          Ending Date:  02/04/91           ║
  3075.  ║                                                                            ║
  3076.  ║                                                                            ║
  3077.  ║                                                                            ║
  3078.  ║      ████████░  ██▄███░    ███░    ▄████░  ██░ ██░  █████░  ██▄███░        ║
  3079.  ║         ██░     ██░ ██░   ██▀██░   ██░     ██░▄██░  ██░     ██░ ██░        ║
  3080.  ║         ██░     ██░ ██░   ██░██░   ██░     ██░██░   ██░     ██░ ██░        ║
  3081.  ║         ██░     ██████░   ██░██░   ██░     ████░    ████░   ██████░        ║
  3082.  ║         ██░     ██░██░    ██▄██░   ██░     ██░██░   ██░     ██░██░         ║
  3083.  ║         ██░     ██░███░  ██▀ ▀██░  ██░     ██░▀██░  ██░     ██░▀██░        ║
  3084.  ║         ██░     ██░ ██░  ██░  ██░  ▀████░  ██░ ██░  █████░  ██░ ██░        ║
  3085.  ╚════════════════════════════════════════════════════════════════════════════╝
  3086.    DAYO Smart Reports,     TJS LAB                                 Page: 39.04
  3087.  
  3088.  
  3089.  
  3090.  
  3091.       Options for this report include the start/end dates, track all or a
  3092.   specific item, specify the Physical Inventory or Last Inventory database
  3093.   file, number of lines per page and to direct output to printer or file.
  3094.  
  3095.  
  3096.  
  3097.  
  3098.  DAYO Smart Reports Version 2.0,  TJS LAB                ┌───[February 1991]──┐
  3099.  ╔══════════════════════════════[ ITEM TRACKER ]══════════════════════════════╗
  3100.  ║   Enter Starting Date:  01/05/90          Ending Date:  02/04/91           ║
  3101.  ║                                                                            ║
  3102.  ║   Track ALL Items!                                                         ║
  3103.  ║                                                                            ║
  3104.  ║   Print all transactions for item?  (Y/N)                                  ║
  3105.  ║                                                                            ║
  3106.  ║   Physical Inventory Database:  \DAYOEOP\PHYINV.DBF                        ║
  3107.  ║                                                                            ║
  3108.  ║   Last Inventory Database:  \DAYOEOP\LASTINV.DBF                           ║
  3109.  ║                                                                            ║
  3110.  ║   Enter number of lines per page:   55                                     ║
  3111.  ║                                                                            ║
  3112.  ║   Send Output to Printer? (Y/N)       ( No -> To File)                     ║
  3113.  ║   Enter File Name:  TRAC0291.TXT                                           ║
  3114.  ║      ████████░  ██▄███░    ███░    ▄████░  ██░ ██░  █████░  ██▄███░        ║
  3115.  ║         ██░     ██░ ██░   ██▀██░   ██░     ██░▄██░  ██░     ██░ ██░        ║
  3116.  ║         ██░     ██░ ██░   ██░██░   ██░     ██░██░   ██░     ██░ ██░        ║
  3117.  ║         ██░     ██████░   ██░██░   ██░     ████░    ████░   ██████░        ║
  3118.  ║         ██░     ██░██░    ██▄██░   ██░     ██░██░   ██░     ██░██░         ║
  3119.  ║         ██░     ██░███░  ██▀ ▀██░  ██░     ██░▀██░  ██░     ██░▀██░        ║
  3120.  ║         ██░     ██░ ██░  ██░  ██░  ▀████░  ██░ ██░  █████░  ██░ ██░        ║
  3121.  ╚════════════════════════════════════════════════════════════════════════════╝
  3122.  
  3123.    DAYO Smart Reports,     TJS LAB                                 Page: 39.05
  3124.  
  3125.  
  3126.  
  3127.       The progress of this report is scrolled onto the screen for the 1st pass
  3128.   through the inventory database (INV.DBF). After reporting all items in the
  3129.   inventory database, the physical inventory and last inventory databases are
  3130.   checked for items not in the inventory database.
  3131.  
  3132.  
  3133.  DAYO Smart Reports Version 2.0,  TJS LAB                ┌───[February 1991]──┐
  3134.  ╔══════════════════════════════[ ITEM TRACKER ]══════════════════════════════╗
  3135.  ║      ████████░  ██▄███░    ███░    ▄████░  ██░ ██░  █████░  ██▄███░        ║
  3136.  ║         ██░     ██░ ██░   ██▀██░   ██░     ██░▄██░  ██░     ██░ ██░        ║
  3137.  ║         ██░     ██░ ██░   ██░██░   ██░     ██░██░   ██░     ██░ ██░        ║
  3138.  ║         ██░     ██████░   ██░██░   ██░     ████░    ████░   ██████░        ║
  3139.  ║         ██░     ██░██░    ██▄██░   ██░     ██░██░   ██░     ██░██░         ║
  3140.  ║         ██░     ██░███░  ██▀ ▀██░  ██░     ██░▀██░  ██░     ██░▀██░        ║
  3141.  ║         ██░     ██░ ██░  ██░  ██░  ▀████░  ██░ ██░  █████░  ██░ ██░        ║
  3142.  ║ Item         Description                      Current   Physical    LastINV║
  3143.  ║ A800470      T/A 16 X 25 X 2                   501.49       4900     501.49║
  3144.  ║ A800460      T/A 16 X 20 X 2                   767.58      12300     491.25║
  3145.  ║ A800460      T/A 16 X 20 X 2                   491.25      12300     491.25║
  3146.  ║ A800390      T/A 24 X 30 X 1                   337.74       3300     337.74║
  3147.  ║ A800070      T/A 10 X 20 X 1                   777.81       7600       0.00║
  3148.  ║ A800040      T/A 20 X 25 X 1                   450.31       4400     450.31║
  3149.  ║ A800030      T/A 20 X 20 X 1                   798.28       7800       0.00║
  3150.  ║ A200695      6-85D36 20X20X36                  828.99       8100       0.00║
  3151.  ║ A200122      AP-15 20 X 25 X 2                 685.70       6700     685.70║
  3152.  ║ A200041      AP-11 16 X 20 X 2                 532.19       5200     532.19║
  3153.  ║ A100230      30/30 18 X 24 X 2                 788.05       7700       0.00║
  3154.  ║ A100130      30/30 24 X 24 X 2                 347.97       3400     347.97║
  3155.  ║ A100110      30/30 20 X 25 X 2                 757.35       7400       0.00║
  3156.  ╚════════════════════════════════════════════════════════════════════════════╝
  3157.  Record:         30/    138        Esc (Exit/Abort)
  3158.    DAYO Smart Reports,     TJS LAB                                 Page: 39.06
  3159.  
  3160.  
  3161.  
  3162.  ■ VIEW REPORTS ON SCREEN
  3163.  
  3164.       This routine was provided to aid the 'fight to stop the cutting down of
  3165.   trees in the world' by offering you the option to view your reports on your
  3166.   screen. The only limitation is on the size of the report. No reports can be
  3167.   viewed if they are over 32,000 bytes. (Just kidding about those trees...)
  3168.  
  3169.       Due to compiler problems (handling of memory), this routine tends to
  3170.   'hang' your computer. It is not recommended you use this option if your
  3171.   machine is performing multitasking programs.
  3172.  
  3173.       At the first prompt, type and enter the name of the report you wish to
  3174.   view.
  3175.  
  3176.  ╔══[ View Reports Onscreen ]═════════════════════════════════════════════════╗
  3177.  ║Use this option to view any report written to disk.                         ║
  3178.  ║Press Enter/Return on an empty prompt to display all files with the         ║
  3179.  ║extension of '.TXT'.                                                        ║
  3180.  ║File size limited to 32,000 bytes.                                          ║
  3181.  ║                                                                            ║
  3182.  ║Enter Report File Name to View On Screen:                                   ║
  3183.  ║                                                                            ║
  3184.  ╚════════════════════════════════════════════════════════════════════════════╝
  3185.  
  3186.  
  3187.       If the file does not exist, or you press enter on an empty prompt, a
  3188.   window will appear showing all reports in the current directory. It is
  3189.   assumed that all reports will have the extension of '.TXT', which is the
  3190.   DAYO standard.
  3191.  
  3192.       All reports are displayed in the window, even if they are too large...
  3193.  
  3194.       ╔═══════════════════════════════════════╗
  3195.       ║   File Name       Size      Date Used ║
  3196.       ╟──────────────┬────────────┬───────────╢
  3197.       ║DAYOERR.TXT   │       1090 │ 06/15/90  ║
  3198.       ║BALANCE.TXT   │       3555 │ 06/15/90  ║
  3199.       ║GL900615.TXT  │         79 │ 06/15/90  ║
  3200.       ║CONFIG.TXT    │       1209 │ 06/15/90  ║
  3201.       ║BUDGETSC.TXT  │       4129 │ 06/15/90  ║
  3202.       ║CLASSRPT.TXT  │       1058 │ 06/02/90  ║
  3203.       ║COA.TXT       │       1158 │ 06/02/90  ║  ┌────────────────────────┐
  3204.       ║GL900602.TXT  │       1759 │ 06/02/90  ║  │ Highlight the Report   │
  3205.       ║PERIODS.TXT   │        968 │ 06/15/90  ║  │ using the Up or Down   │
  3206.       ║TRANS3.TXT    │        659 │ 06/02/90  ║  │ arrow keys, then press │
  3207.       ║TRIAL.TXT     │       6712 │ 06/15/90  ║  │ Enter/Return.          │
  3208.       ║INC_EXP.TXT   │       3291 │ 06/15/90  ║  └────────────────────────┘
  3209.       ║TRANS1.TXT    │        659 │ 06/15/90  ║
  3210.       ║ASSETS.TXT    │       1300 │ 06/15/90  ║
  3211.       ║LIABIL.TXT    │       1987 │ 06/15/90  ║
  3212.       ║EQUITY.TXT    │        714 │ 06/15/90  ║
  3213.       ╚══════════════╧════════════╧═══════════╝
  3214.    DAYO Smart Reports,     TJS LAB                                   Page: 40
  3215.  
  3216.  
  3217.  
  3218.  ■ REPORT VIEWING SCREEN
  3219.  
  3220.  
  3221.       The report viewing screen uses the complete screen. The top line
  3222.   displays the report name. The bottom lines show you the function keys,
  3223.   all 2 of them. Also displayed at the bottom of the screen is the current
  3224.   row/column of the cursor position.
  3225.  
  3226.  
  3227.  
  3228.  DAYORPT View Reports   │   File Name: COA.TXT
  3229.  
  3230.  
  3231.         Page No.     1
  3232.         07/27/90
  3233.                                  INVENTORY ITEM LISTING
  3234.  
  3235.  
  3236.                      Vendor or
  3237.         Item         Mfg Item     Description
  3238.         ------------ ------------ ------------------------------
  3239.  
  3240.         2" GUTTER                 2" GUTTER SYSTEM               _____________
  3241.         2ALM518                   2" ALMOND COIL                 _____________
  3242.         2ALM519                   2" ALMOND COIL                 _____________
  3243.         2ALM527                   2" ALMOND COIL                 _____________
  3244.         2ALM533                   2" ALMOND COIL                 _____________
  3245.         2ANT123                   2" ANT IVORY COIL              _____________
  3246.  
  3247.  
  3248.     Esc (Exit)   F1 (Help)
  3249.    DAYO Smart Reports,     TJS LAB                                   Page: 41
  3250.  
  3251.  
  3252.  
  3253.  ■ PRINTER DRIVER (SETUP)
  3254.  
  3255.       This routine was added to preclude you from having to get out of your
  3256.   seat to change (mess with) the printer to get it to print correctly.
  3257.  
  3258.       The most important printer selections (ie: font size, lines per inch,
  3259.   orientation, ...) are made easy to evoke.
  3260.  
  3261.  ╔════════════════════════════════════════════════════════════════════════════╗
  3262.  ║    █▄██░█▄██░███░█░  █░█████░███░█▄██░    █▄██▄ █▄██░███░█░  █░███░█▄██░   ║
  3263.  ║    █░ █░█░ █░ █░ ██░ █░  █░  █░  █░ █░    █░  █░█░ █░ █░ █░  █░█░  █░ █░   ║
  3264.  ║    █▀██░████░ █░ ███░█░  █░  ██░ ████░    █░  █░████░ █░ █▄ ▄█░██  ████░   ║
  3265.  ║    █░   █░█░  █░ █░███░  █░  █░  █░█░     █░  █░█░█░  █░  █░█░ █░  █░█░    ║
  3266.  ║    █░   █░▀█░ █░ █░ ██░  █░  █░  █░▀█░    █░  █░█░▀█░ █░  █▄█░ █░  █░▀█░   ║
  3267.  ║    █░   █░ █░███░█░  █░  █░  ███░█░ █░    █▀██▀ █░ █░███░  █░  ███░█░ █░   ║
  3268.  ║                                                                            ║
  3269.  ║                     Select Option -> Eject                                 ║
  3270.  ║                                      Line feed                             ║
  3271.  ║                                      Normal Size                           ║
  3272.  ║   Use this routine to set your       Small/Condensed                       ║
  3273.  ║   printer up with one or more        Bold On                               ║
  3274.  ║   of the setup strings and           Bold Off                              ║
  3275.  ║   commands listed to the right.      6 Lines per Inch                      ║
  3276.  ║                                      8 Lines per Inch                      ║
  3277.  ║   Select the 'Change Printer         Print Landscape (Laser Only)          ║
  3278.  ║   Default' option to change          Print Portrait  (Laser Only)          ║
  3279.  ║   printer types.                     Reset Printer                         ║
  3280.  ║   Current printer is set to:         Print Special String 1                ║
  3281.  ║   Okidata                            Print Special String 2                ║
  3282.  ║                                      Print Special String 3                ║
  3283.  ╚════════════════════════════════════════════════════════════════════════════╝
  3284.    Esc (Exit)
  3285.  
  3286.  
  3287.  
  3288.  ■ PRINTER DRIVER OPTIONS
  3289.  
  3290.       There are 18 printer driver options to select from. The last option is
  3291.   to set the default printer, and the next to last is a 'SHELL' function that
  3292.   runs a DOS command or program. The remainder are strings/codes that are sent
  3293.   to the printer.
  3294.  
  3295.  
  3296.            Eject                             Print Portrait  (Laser Only)
  3297.            Line feed                         Reset Printer
  3298.            Normal Size                       Print Special String 1
  3299.            Small/Condensed                   Print Special String 2
  3300.            Bold On                           Print Special String 3
  3301.            Bold Off                          Print Special String 4
  3302.            6 Lines per Inch                  Print Special String 5
  3303.            8 Lines per Inch                  Run DOS Command/Program
  3304.            Print Landscape (Laser Only)      Change Default Printer
  3305.    DAYO Smart Reports,     TJS LAB                                   Page: 42
  3306.  
  3307.  
  3308.  
  3309.  ■ CHANGE DEFAULT PRINTER
  3310.  
  3311.       The last option is to change/set the default printer. This printer
  3312.   driver routine comes with 4 default printer types, Epson, HP Laser, Star,
  3313.   and Okidata.
  3314.  
  3315.       You can add (Ctrl N) as many as you want.
  3316.  
  3317.  ╔════════════════════════════════════════════════════════════════════════════╗
  3318.  ║    █▄██░█▄██░███░█░  █░█████░███░█▄██░    █▄██▄ █▄██░███░█░  █░███░█▄██░   ║
  3319.  ║    █░ █░█░ █░ █░ ██░ █░  █░  █░  █░ █░    █░  █░█░ █░ █░ █░  █░█░  █░ █░   ║
  3320.  ║    █▀██░████░ █░ ███░█░  █░  ██░ ████░    █░  █░████░ █░ █▄ ▄█░██  ████░   ║
  3321.  ║    █░   █░█░  █░ █░███░  █░  █░  █░█░     █░  █░█░█░  █░  █░█░ █░  █░█░    ║
  3322.  ║    █░   █░▀█░ █░ █░ ██░  █░  █░  █░▀█░    █░  █░█░▀█░ █░  █▄█░ █░  █░▀█░   ║
  3323.  ║    █░   █░ █░███░█░  █░  █░  ███░█░ █░    █▀██▀ █░ █░███░  █░  ███░█░ █░   ║
  3324.  ╟────────────────────────────────────────────────────────────────────────────╢
  3325.  ║   Current Default Printer is set to: Okidata                               ║
  3326.  ╟────────────────────────────────────────────────────────────────────────────╢
  3327.  ║      NAME                             LINEFEED                             ║
  3328.  ║─────────────────────────────────────╥──────────────────────────────────────║
  3329.  ║      Epson & Compatibles            ║ CHR(10)                              ║
  3330.  ║      HP Laser & Compatibles         ║ CHR(10)                              ║
  3331.  ║      Star Micro Gemini              ║ CHR(10)                              ║
  3332.  ║      Okidata                        ║ CHR(10)                              ║
  3333.  ║                                     ║                                      ║
  3334.  ║                                     ║                                      ║
  3335.  ║                                     ║                                      ║
  3336.  ║                                     ║                                      ║
  3337.  ║                                     ║                                      ║
  3338.  ╚════════════════════════════════════════════════════════════════════════════╝
  3339.   Esc (Exit)   Enter/Return (Make Default)   F2 (Edit)   Ctrl N (Add)
  3340.                                                           1/4
  3341.    DAYO Smart Reports,     TJS LAB                                   Page: 43
  3342.  
  3343.  
  3344.  
  3345.  ■ FULL SCREEN EDIT - F2
  3346.  
  3347.  
  3348.       When entering the printer codes, the string must be in the valid format
  3349.   or it will not be printed later when requested...
  3350.  
  3351.  ┌───────────[ EDIT PRINTER DRIVER SETUP CODES - FULL SCREEN EDIT ]───────────┐
  3352.  │   NAME:        Epson & Compatibles                                         │
  3353.  │   LINEFEED:    CHR(10)                                                     │
  3354.  │   NORMAL:      CHR(27)+CHR(18)                                             │
  3355.  │   SMALL:       CHR(27)+CHR(15)                                             │
  3356.  │   BOLDON:      CHR(27)+CHR(69)                                             │
  3357.  │   BOLDOFF:     CHR(27)+CHR(70)                                             │
  3358.  │   _6LPI:       CHR(27)+CHR(50)                                             │
  3359.  │   _8LPI:       CHR(27)+CHR(48)                                             │
  3360.  │   PORTRAIT:                                                                │
  3361.  │   LANDSCAPE:                                                               │
  3362.  │   RESET:       CHR(27)+CHR(64)                                             │
  3363.  │   SPEC_STR1:                                                               │
  3364.  │   SPEC_STR2:                                                               │
  3365.  │   SPEC_STR3:                                                               │
  3366.  │   SPEC_STR4:                                                               │
  3367.  │   SPEC_STR5:                                                               │
  3368.  │   RUN_CMD:                                                                 │
  3369.  │                                                                            │
  3370.  │                                                                            │
  3371.  └────────────────────────────────────────────────────────────────────────────┘
  3372.   Press   Esc  to Abort,  PgUp/PgDn  to Save and Exit
  3373.  
  3374.  
  3375.  
  3376.  ■ PRINTER DRIVER DATABASE FIELD DEFINITIONS
  3377.  
  3378.   NAME       - Name of printer. Type in anything you wish here
  3379.   LINEFEED   - Code to advance printer one line
  3380.   NORMAL     - Normal font/character size
  3381.   SMALL      - Small font/character size
  3382.   BOLDON     - Bold/Emphasized
  3383.   BOLDOFF    - Bold/Emphasized off
  3384.   _6LPI      - Code to set printer to print 6 lines per inch
  3385.   _8LPI      - Code to set printer to print 8 lines per inch
  3386.   PORTRAIT   - Code to set lazer printer to print upright (normal)
  3387.   LANDSCAPE  - Code to set lazer printer to print sideways
  3388.   RESET      - Reset printer code
  3389.   SPEC_STR1  - Any special printer string, ie: print double, skip perforation,
  3390.   SPEC_STR2  -     print very tiny, ...
  3391.   SPEC_STR3  -  "
  3392.   SPEC_STR4  -  "
  3393.   SPEC_STR5  -  "
  3394.   RUN_CMD    - DOS command or program, ie: CAPTURE p0 nff,SPOOL ON, ...
  3395.  
  3396.  
  3397.  
  3398.    DAYO Smart Reports,     TJS LAB                                   Page: 44
  3399.  
  3400.  
  3401.  
  3402.  ■ CONFIGURATION
  3403.  
  3404.  
  3405.       The configurations settings (14 of them), are all accessed from within
  3406.   the CONFIGURATION menu (first option from the main menu).
  3407.  
  3408.  
  3409.  
  3410.                           ╔════════════════════════╗
  3411.                           ║     CONFIGURATION      ║
  3412.                           ╟────────────────────────╢
  3413.                           ║ Company Name           ║
  3414.                           ║ Company Address        ║
  3415.                           ║ Company Telephone      ║
  3416.                           ║ Inventory Location     ║
  3417.                           ║ POS Location           ║
  3418.                           ║ Customer Location      ║
  3419.                           ║ AP Location            ║
  3420.                           ║ Quotes Location        ║
  3421.                           ║ Back Orders Location   ║
  3422.                           ║ Price Book Location    ║
  3423.                           ║ Report Printer Type    ║
  3424.                           ║ Report Printer Port    ║
  3425.                           ║ Color                  ║
  3426.                           ║ High Intensity         ║
  3427.                           ║                        ║
  3428.                           ╟────────────────────────╢
  3429.                           ║     Select Option      ║
  3430.                           ╚════════════════════════╝
  3431.  
  3432.  
  3433.  
  3434.  
  3435.  ■ CONFIGURATION LISTING
  3436.  
  3437.  
  3438.                  Company Name             Quotes Location
  3439.                  Company Address          Back Orders Location
  3440.                  Company Telephone        Price Book Location
  3441.                  Inventory Location       Report Printer Type
  3442.                  POS Location             Report Printer Port
  3443.                  Customer Location        Color
  3444.                  AP Location              High Intensity
  3445.  
  3446.  
  3447.    DAYO Smart Reports,     TJS LAB                                   Page: 45
  3448.  
  3449.  
  3450.  
  3451.  ■ COMPANY NAME, ADDRESS & TELEPHONE
  3452.  
  3453.       Each field for this option is limited to 30 characters, 14 for the
  3454.   telephone...
  3455.  
  3456.  ┌──────────────────────────────[ COMPANY NAME ]──────────────────────────────┐
  3457.  │   Enter Your Company Name:  YOUR COMPANY, INC                              │
  3458.  └────────────────────────────────────────────────────────────────────────────┘
  3459.  
  3460.  
  3461.  ┌────────────────────────────[ COMPANY ADDRESS ]─────────────────────────────┐
  3462.  │     Address Line 1:  Attn: Accounting                                      │
  3463.  │     Address Line 2:  P.O. BOX 5555                                         │
  3464.  │   City, State  ZIP:  ANYCITY, ST  55555-5555                               │
  3465.  └────────────────────────────────────────────────────────────────────────────┘
  3466.  
  3467.  
  3468.  ┌───────────────────────────[ COMPANY TELEPHONE ]────────────────────────────┐
  3469.  │   Enter Your Company Telephone:  800-555-5555                              │
  3470.  └────────────────────────────────────────────────────────────────────────────┘
  3471.  
  3472.  
  3473.  
  3474.  ■ INVENTORY LOCATION/DIRECTORY
  3475.  
  3476.  ┌──────────────────────[ INVENTORY LOCATION/DIRECTORY ]──────────────────────┐
  3477.  │ The location of the DAYO Inventory (INV.DBF) does not have to be in the    │
  3478.  │ same drive/directory as DAYO Reports. If you have installed DAYO Inventory │
  3479.  │ into a different directory, you need to tell DAYO Reports where to find    │
  3480.  │ the inventory database (INV.DBF).  Default is nil (current directory).     │
  3481.  │ Be sure to include the rightmost slash, ie:  \DAYOINV\                     │
  3482.  │ The drive designation is optional (if same as DAYO Reports).               │
  3483.  │                                                                            │
  3484.  │   Enter Location:  \DAYOINV\                                               │
  3485.  └────────────────────────────────────────────────────────────────────────────┘
  3486.  
  3487.  
  3488.  
  3489.  ■ POINT OF SALE (POS) DATABASES LOCATION/DIRECTORY
  3490.  
  3491.  ┌────────────[ POINT OF SALE (POS) DATABASES LOCATION/DIRECTORY ]────────────┐
  3492.  │ The location of the DAYO POS files (ie INVOICE.DBF) does not have to be    │
  3493.  │ in the same drive/directory as DAYO Reports. If you have installed the     │
  3494.  │ DAYO POS Databases, into a different directory, you need to tell DAYO      │
  3495.  │ Reports where to find it. Default is nil (current directory).              │
  3496.  │ Be sure to include the rightmost slash, ie:  \DAYOPOS\                     │
  3497.  │ The drive designation is optional (if same as DAYO Reports).               │
  3498.  │                                                                            │
  3499.  │   Enter Location:  \DAYOPOS\                                               │
  3500.  └────────────────────────────────────────────────────────────────────────────┘
  3501.    DAYO Smart Reports,     TJS LAB                                   Page: 46
  3502.  
  3503.  
  3504.  
  3505.  ■ CUSTOMER DATABASE LOCATION/DIRECTORY
  3506.  
  3507.  ┌──────────────────[ CUSTOMER DATABASE LOCATION/DIRECTORY ]──────────────────┐
  3508.  │ The location of the DAYO Customer file (CUSTOMER.DBF) does not have to be  │
  3509.  │ in the same drive/directory as DAYO Reports. If you have installed the     │
  3510.  │ DAYO Customer Database (CUSTOMER.DBF), into a different directory, you need│
  3511.  │ to tell DAYO Reports where to find it. Default is nil (current directory). │
  3512.  │ Be sure to include the rightmost slash, ie:  \DAYOAR\                      │
  3513.  │ The drive designation is optional (if same as DAYO Reports).               │
  3514.  │                                                                            │
  3515.  │   Enter Location:  \DAYOAR\                                                │
  3516.  └────────────────────────────────────────────────────────────────────────────┘
  3517.  
  3518.  
  3519.  
  3520.  ■ ACCOUNTS PAYABLE DATABASES LOCATION/DIRECTORY
  3521.  
  3522.  ┌─────────────[ ACCOUNTS PAYABLE DATABASES LOCATION/DIRECTORY ]──────────────┐
  3523.  │ The location of the DAYO AP files (ie: APH.DBF) does not have to be        │
  3524.  │ in the same drive/directory as DAYO Reports. If you have installed the     │
  3525.  │ DAYO AP Databases, into a different directory, you need to tell DAYO       │
  3526.  │ Reports where to find them. Default is nil (current directory).            │
  3527.  │ Be sure to include the rightmost slash, ie:  \DAYOAP\                      │
  3528.  │ The drive designation is optional (if same as DAYO Reports).               │
  3529.  │                                                                            │
  3530.  │   Enter Location:  \DAYOAP\                                                │
  3531.  └────────────────────────────────────────────────────────────────────────────┘
  3532.  
  3533.  
  3534.  
  3535.  ■ QUOTES DATABASE LOCATION/DIRECTORY
  3536.  
  3537.  ┌───────────────────[ QUOTES DATABASE LOCATION/DIRECTORY ]───────────────────┐
  3538.  │ The location of the DAYO Quotes Database (QUOTES.DBF) does not have to be  │
  3539.  │ in the same drive/directory as DAYO Reports. If you have installed DAYO    │
  3540.  │ Quotes into a different directory, you need to tell DAYO Reports where to  │
  3541.  │ find the quotes database (QUOTES.DBF). Default is nil (current directory). │
  3542.  │ Be sure to include the rightmost slash, ie:  \DAYOQUO\                     │
  3543.  │ The drive designation is optional (if same as DAYO Reports).               │
  3544.  │                                                                            │
  3545.  │   Enter Location:  \DAYOQUO\                                               │
  3546.  └────────────────────────────────────────────────────────────────────────────┘
  3547.    DAYO Smart Reports,     TJS LAB                                   Page: 47
  3548.  
  3549.  
  3550.  
  3551.  ■ BACKORDERS DATABASE LOCATION/DIRECTORY
  3552.  
  3553.  ┌─────────────────[ BACKORDERS DATABASE LOCATION/DIRECTORY ]─────────────────┐
  3554.  │ The location of the DAYO BackOrder Database (BO.DBF) does not have to      │
  3555.  │ be in the same drive/directory as DAYO Reports. If you have installed DAYO │
  3556.  │ BO into a different directory, you need to tell DAYO Reports where to find │
  3557.  │ the BackOrder database (BO.DBF).  Default is nil (current directory).      │
  3558.  │ Be sure to include the rightmost slash, ie:  \DAYOBO\                      │
  3559.  │ The drive designation is optional (if same as DAYO Reports).               │
  3560.  │                                                                            │
  3561.  │   Enter Location:  \DAYOBO\                                                │
  3562.  └────────────────────────────────────────────────────────────────────────────┘
  3563.  
  3564.  
  3565.  
  3566.  ■ PRICE BOOK DATABASE LOCATION/DIRECTORY
  3567.  
  3568.  ┌─────────────────[ PRICE BOOK DATABASE LOCATION/DIRECTORY ]─────────────────┐
  3569.  │ The location of the DAYO Price Book Database (PB.DBF) does not have to be  │
  3570.  │ in the same drive/directory as DAYO Reports. If you have installed DAYOPB  │
  3571.  │ into a different directory, you need to tell DAYO Reports where to find    │
  3572.  │ the price book database (PB.DBF).  Default is nil (current directory).     │
  3573.  │ Be sure to include the rightmost slash, ie:  \DAYOPB\                      │
  3574.  │ The drive designation is optional (if same as DAYO Reports).               │
  3575.  │                                                                            │
  3576.  │   Enter Location:  \DAYOPB\                                                │
  3577.  └────────────────────────────────────────────────────────────────────────────┘
  3578.  
  3579.  
  3580.  
  3581.  ■ REPORT PRINTER TYPE
  3582.  
  3583.  ┌──────────────────────────[ REPORT PRINTER TYPE ]───────────────────────────┐
  3584.  │   Routine reports are printed according to this selection.                 │
  3585.  │   The STANDARD printer type is a Epson/IBM Proprinter compatible printer.  │
  3586.  │   The LASER printer type is a Hewlett Packard Laser compatible printer.    │
  3587.  │   Special Laser codes are sent to the LASER option.                        │
  3588.  │                                                                            │
  3589.  │   Enter Your Report Printer Type -> STANDARD                               │
  3590.  │                                     LASER                                  │
  3591.  └────────────────────────────────────────────────────────────────────────────┘
  3592.  
  3593.  
  3594.  
  3595.  ■ REPORT PRINTER PORT
  3596.  
  3597.  ┌──────────────────────────[ REPORT PRINTER PORT ]───────────────────────────┐
  3598.  │   Enter Your Report Printer Port (1,2,3):  1                               │
  3599.  └────────────────────────────────────────────────────────────────────────────┘
  3600.    DAYO Smart Reports,     TJS LAB                                   Page: 48
  3601.  
  3602.  
  3603.  
  3604.  ■ COLOR MONITOR
  3605.  
  3606.       To activate a color change, you must completely exit DAYO Smart Reports,
  3607.   then reenter.
  3608.  
  3609.  ┌─────────────────────────────[ COLOR MONITOR ]──────────────────────────────┐
  3610.  │   If you have a color monitor and wish to display colors, then select Y,   │
  3611.  │   (YES), else select  N (NO) for monochrome and others.                    │
  3612.  │   The default is color, low intensity                                      │
  3613.  │                                                                            │
  3614.  │   Do you have a color monitor? (Y/N)                                       │
  3615.  └────────────────────────────────────────────────────────────────────────────┘
  3616.  
  3617.  
  3618.  
  3619.  ■ COLOR INTENSITY
  3620.  
  3621.  ┌────────────────────────────[ COLOR INTENSITY ]─────────────────────────────┐
  3622.  │   Intensity is only applicable with color set to  Y.                       │
  3623.  │   It will make your colors brighter...                                     │
  3624.  │                                                                            │
  3625.  │   Set Color Intensity On?  (Y/N)                                           │
  3626.  └────────────────────────────────────────────────────────────────────────────┘
  3627.  
  3628.    DAYO Smart Reports,     TJS LAB                                   Page: 49
  3629.                                                                                
  3630.                                                                                
  3631.                                                                                
  3632.  ■ MISCELLANEOUS ROUTINES
  3633.  
  3634.                                                                                
  3635. - The MISC routines is a collection of 17 very useful Database Management
  3636.   Routines. These routines provide you with the 'ability to do whatever was
  3637.   left out of the rest of the program...'. These routines were modeled after
  3638.   dBase (tm) III+/IV functions. Familiarity with dBase will help with the
  3639.   understanding and execution of these routines.
  3640.  
  3641.                                                                                
  3642.             USE WITH CAUTION!                                                  
  3643.             YOU CAN ENHANCE AND CUSTOMIZE YOUR PROGRAM WITH THESE ROUTINES     
  3644.             YOU CAN ALSO MESS THINGS UP PERMANENTLY!                           
  3645.                                                                                
  3646.                                                                                
  3647.                                                                                
  3648.  ■ MISC ROUTINES MENU:
  3649.  
  3650.  
  3651.  
  3652.  DAYORPT V2.0,  TJS LAB                                  ┌────[April 1990]────┐
  3653.  ╔════════════════════╗                                  │S  M  T  W  T  F  S │
  3654.  ║   MISC ROUTINES    ║═══╗   ████▄   ▄█▄  █░  █░ ▄███▄  ├────────────────────┤
  3655.  ╟────────────────────╢   ║   █░  █░  █░█░ █░  █░ █░  █░ │ 1  2  3  4  5  6  7│
  3656.  ║  APPEND FROM       ║   ║   █░  █░  █░█░ ▀█░██░ █░  █░ │ 8  9 10 11 12 13 14│
  3657.  ║  BROWSE DATABASES  ║   ║   █░  █░ █▀▀▀█░ ▀█▀   █░  █░ │15 16 17 18 19 20 21│
  3658.  ║  COPY (.DBF) TO    ║   ║   █░  █░ █░  █░  █░   █░  █░ │22 23 24 25 26 27 28│
  3659.  ║  CREATE DATABASE   ║   ║   ████▀  █░  █░  █░   ▀███▀  │29 30               │
  3660.  ║  DELETE RECORDS    ║   ║                              │                    │
  3661.  ║  ERASE FILE        ║   ║                              └────────────────────┘
  3662.  ║  EXIT TO DOS       ║   ╠═[ Misc Routines ]═════════════════════════════════╗
  3663.  ║  INDEX A DATABASE  ║   ║                                                   ║
  3664.  ║  LIST FIELDS       ║   ║ Miscellaneous Database Management Routines.       ║
  3665.  ║  PACK DATABASE     ║   ║                                                   ║
  3666.  ║  MODIFY DATABASE   ║   ║ Browse, Edit, Append, Copy, Delete, Pack,         ║
  3667.  ║  RECALL RECORDS    ║═══╣ Modify, and/or Create Databases.                  ║
  3668.  ║  RETURN TO MENU    ║   ║                                                   ║
  3669.  ║  RUN (DOS COMMAND) ║═══╩═══════════════════════════════════════════════════╝
  3670.  ║  SIMPLE EDITOR     ║ █▄█▄  ███░       █▄█▄  ███░ █▄█▄  ▄█▄  █▄█▄  ███░ ▄██▄
  3671.  ║  SORT DATABASE     ║ █░ █░  █░        █░ █░ █░   █░ █░ █░█░ █░ █░  █░  █░
  3672.  ║  TYPE (PRINT) FILE ║ █▄▄█░  █░        █▄▄█░ ██░  █▄▄█░ █░█░ █▄▄█░  █░  █░
  3673.  ║  ZAP DATABASE      ║ █▀█░   █░        █▀█░  █░   █░    █░█░ █▀█░   █░  ▀██▄
  3674.  ╟────────────────────╢ █░█▄   █░        █░█▄  █░   █░    █░█░ █░█▄   █░     █░
  3675.  ║   Select Option    ║ █░ █░  █░        █░ █░ ███░ █░    ▀█▀  █░ █░  █░  ▀██▀
  3676.  ╚════════════════════╝
  3677.  
  3678.    DAYO Smart Reports,     TJS LAB                                   Page: 50
  3679.                                                                                
  3680.                                                                                
  3681.                                                                                
  3682.  ■ APPEND FROM                                                                 
  3683.                                                                                
  3684.  - Used to copy records from one database into another database, or to create  
  3685.    records from ASCII files (SDF or DELIMITED).                                
  3686.                                                                                
  3687.  - The Initial Screen will prompt you to enter the file name of the database   
  3688.    you are to append/copy the data into. At this point, you can either type in 
  3689.    the name of the target database, or ...                                     
  3690.                                                                                
  3691.  ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐
  3692.  │   Enter Database Name To Append Data Into:                                 │
  3693.  │   Enter Nothing For Listing Of Current Directory...                        │
  3694.  └────────────────────────────────────────────────────────────────────────────┘
  3695.                                                                                
  3696.  -  If it exists in the current directory, press enter on an empty prompt to   
  3697.     display all databases to select from.                                      
  3698.                                                                                
  3699.                                                                                
  3700.  ┌──────────────────────────────[ APPEND FROM ]──────────────────────────────┐ 
  3701.  │                                                                           │ 
  3702.  │   Enter Database Name To Append Data Into:                                │ 
  3703.  │   Enter┌────────[ PICK A DATABASE ]───────────┐y...                       │ 
  3704.  │        │ FILE NAME      SIZE         DATE USED│                           │ 
  3705.  │        ├──────────────┬────────────┬──────────┤                           │ 
  3706.  │        │INVENT.DBF    │        375 │ 09/16/89 │                           │ 
  3707.  │        │AR.DBF        │       7219 │ 09/16/89 │                           │ 
  3708.  │        │HISTORY.DBF   │        103 │ 09/16/89 │                           │ 
  3709.  │        │PERSONS.DBF   │      24271 │ 09/16/89 │                           │ 
  3710.  │        │CUSTOMER.DBF  │        289 │ 09/16/89 │                           │ 
  3711.  │        └──────────────┴────────────┴──────────┘                           │ 
  3712.  │                                                  ┌───────────────────────┐│ 
  3713.  │                                                  │ Highlight a database  ││ 
  3714.  │                                                  │ using the             ││ 
  3715.  │                                                  │ arrow keys, then press││ 
  3716.  │                                                  │ Enter/Return.         ││ 
  3717.  │                                                  └───────────────────────┘│ 
  3718.  │                                                                           │ 
  3719.  └───────────────────────────────────────────────────────────────────────────┘ 
  3720.                                                                                
  3721.  - The next prompt will be to select the type of Append:                       
  3722.                                                                                
  3723.  ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐  
  3724.  │                                                                          │  
  3725.  │   Enter Database Name To Append Data Into:                               │  
  3726.  │   Enter Nothing For Listing Of Current Directory...                      │  
  3727.  │                                                                          │  
  3728.  │   Append Data Into INVENT.DBF                                            │  
  3729.  │                                                                          │  
  3730.  │   Type of Append:     Standard     SDF     DELIMITED                     │  
  3731.  │                                                                          │  
  3732.  └──────────────────────────────────────────────────────────────────────────┘  
  3733.    DAYO Smart Reports,    TJS LAB                                    Page: 51
  3734.                                                                                
  3735.                                                                                
  3736.                                                                                
  3737.  - If you are appending from another database (.DBF) then select 'Standard'.   
  3738.                                                                                
  3739.  - Select the SDF option if you are appending from a 'flat' ASCII file.        
  3740.                                                                                
  3741.  - Select the DELIMITED option if you are appending from a delimited ASCII     
  3742.    file. Delimited files contain records in which the fields are separated by  
  3743.    commas, and its character fields contained in double quotes...              
  3744.                                                                                
  3745.  - If you select a Standard Append, you will then be prompted to enter the name
  3746.    of the database you wish to get the data from. If you selected the SDF or   
  3747.    DELIMITED options, then enter the file name containing the data to be       
  3748.    appended into your target database.                                         
  3749.                                                                                
  3750.                                                                                
  3751.  ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐  
  3752.  │                                                                          │  
  3753.  │   Enter Database Name To Append Data Into:                               │  
  3754.  │   Enter Nothing For Listing Of Current Directory...                      │  
  3755.  │                                                                          │  
  3756.  │   Append Data Into PERSONS.DBF                                           │  
  3757.  │                                                                          │  
  3758.  │   Type of Append:     Standard     SDF     DELIMITED                     │  
  3759.  │                                                                          │  
  3760.  │   Enter Database Name To Append Data FROM:  PERSON1.TXT                  │  
  3761.  │                                                                          │  
  3762.  │                                                                          │  
  3763.  └──────────────────────────────────────────────────────────────────────────┘  
  3764.                                                                                
  3765.  - The number of records appended into the target database will be displayed   
  3766.    upon completion of the task...                                              
  3767.                                                                                
  3768.  ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐
  3769.  │                                                                            │
  3770.  │   Enter Database Name To Append Data Into:                                 │
  3771.  │   Enter Nothing For Listing Of Current Directory...                        │
  3772.  │                                                                            │
  3773.  │   Append Data Into INVENT.DBF From INVENTY.DBF                             │
  3774.  │                                                                            │
  3775.  │   Type of Append:     Standard     SDF     DELIMITED                       │
  3776.  │                                                                            │
  3777.  │   Enter Database Name To Append Data FROM:  INVENT.DBF                     │
  3778.  │                                                                            │
  3779.  │                                                                            │
  3780.  │                                                                            │
  3781.  │   There Were 1 Records Appended Into INVENT.DBF                            │
  3782.  │                                                                            │
  3783.  │                                                                            │
  3784.  │                                                                            │
  3785.  │   Press Any Key To Continue...                                             │
  3786.  │                                                                            │
  3787.  └────────────────────────────────────────────────────────────────────────────┘
  3788.    DAYO Smart Reports,    TJS LAB                                    Page: 52
  3789.                                                                                
  3790.                                                                                
  3791.                                                                                
  3792.  ■ BROWSE DATABASES                                                            
  3793.                                                                                
  3794.  - Used to edit/view records in a database. Enter the database name you wish to
  3795.    edit/browse, or if it exists in the current directory, press enter on an    
  3796.    empty prompt to bring up a window box to select from.                       
  3797.                                                                                
  3798.           ┌───────────────────────────────────────────────────────────────┐    
  3799.           │ Enter Database Name: INVENT.DBF                               │    
  3800.           │                                                               │    
  3801.           └───────────────────────────────────────────────────────────────┘    
  3802.                                                                                
  3803.  - If there exists an index (.NDX or .NTX), with the same name as the database,
  3804.    it will be utilized... The DAYO Inventory indexes are the exception. They   
  3805.    are automatically set/used.                                                 
  3806.                                                                                
  3807.                                                                                
  3808.  - An example of a browse screen:                                              
  3809.                                                                                
  3810.  TJS LAB, PO BOX 585366                                                        
  3811.  ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐
  3812.  │  MFG_PART          DESC                             PRICE        LIST      │
  3813.  │──────────────────╥────────────────────────────────╥────────────╥───────────│
  3814.  │            19730 ║ DAYO CONFIGURATION SETTINGS    ║     896.16 ║   1792.32 │
  3815.  │            23429 ║ DAYO CUSTOMER                  ║    1064.19 ║   2128.38 │
  3816.  │            14797 ║ DAYO END OF PERIOD/DAY         ║     672.12 ║   1344.24 │
  3817.  │            38227 ║ DAYO FINANCE,PERSONNEL,PAYROLL ║    1736.31 ║   3472.62 │
  3818.  │            11098 ║ DAYO INVENTORY                 ║     504.09 ║   1008.18 │
  3819.  │            17264 ║ DAYO MISC ROUTINES             ║     784.14 ║   1568.28 │
  3820.  │            30828 ║ DAYO PICK, INVOICING           ║    1400.25 ║   2800.50 │
  3821.  │            35760 ║ DAYO PURCHASE ORDERS           ║    1624.29 ║   3248.58 │
  3822.  │            25896 ║ DAYO QUOTES                    ║    1176.21 ║   2352.42 │
  3823.  │            62889 ║ DAYO ROPA                      ║    2856.51 ║   5713.02 │
  3824.  │            64122 ║ DAYO ROPA/ROPC SOURCE          ║    2912.52 ║   5825.04 │
  3825.  │            28362 ║ DAYO SALES ORDERS, P.O.S.      ║    1288.23 ║   2576.46 │
  3826.  │            33294 ║ DAYO VENDORS                   ║    1512.27 ║   3024.54 │
  3827.  │            66588 ║ DBASE TRAINING (PER HOUR)      ║    3024.54 ║   6049.08 │
  3828.  │            16031 ║ EOP SOURCE                     ║     728.13 ║   1456.26 │
  3829.  │            49325 ║ EXPENSES SOURCE                ║    2240.40 ║   4480.80 │
  3830.  │            39460 ║ FINANCE SOURCE                 ║    1792.32 ║   3584.64 │
  3831.  ├──────────────────╨────────────────────────────────╨────────────╨───────────┤
  3832.  │ Esc(EXIT)   Ctrl N(ADD)   Ctrl U(DELETE)   F5(Find)                        │
  3833.  └────────────────────────────────────────────────────────────────────────────┘
  3834.                                                           51/60                
  3835.    DAYO Smart Reports,    TJS LAB                                    Page: 53
  3836.                                                                                
  3837.                                                                                
  3838.                                                                                
  3839.  - To edit a memo field, just highlight the field, and start typing.           
  3840.                                                                                
  3841.                                                                                
  3842.  * * * To save your work, once finished, YOU MUST PRESS  Ctrl W  UPON EXITING! 
  3843.                                                                                
  3844.                                                                                
  3845.  ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐
  3846.  │            PRICE        LIST         YOURPART          NOTES               │
  3847.  │───────────────────────╥────────────╥─────────────────╥─────────────────────│
  3848.  │                896.16 ║    1792.32 ║                 ║   <Memo>            │
  3849.  │               1064.19 ║    2128.38 ║                 ║   <Memo>            │
  3850.  │                672.12 ║    1344.24 ║                 ║   <Memo>            │
  3851.  │               1736.31 ║    3472.62 ║                 ║   <Memo>            │
  3852.  │                504.09 ║    1008.18 ║                 ║   <Memo>            │
  3853.  │                784.14 ║    1568.28 ║                 ║   <Memo>            │
  3854.  │               1400.25 ║    2800.50 ║                 ║   <Memo>            │
  3855.  ┌────────────────────────────[ Edit Field: NOTES ] ──────────────────────────┐
  3856.  │You can edit memo fields too...                                             │
  3857.  │                                                                            │
  3858.  │                                                                            │
  3859.  │                                                                            │
  3860.  │                                                                            │
  3861.  │                                                                            │
  3862.  │                                                                            │
  3863.  └───────────────────────[ Esc (ABORT)    Ctrl W (SAVE) ]─────────────────────┘
  3864.  │ Esc(EXIT)   Ctrl N(ADD)   Ctrl U(DELETE)   F5(Find)                        │
  3865.  └────────────────────────────────────────────────────────────────────────────┘
  3866.                                                                                
  3867.                                                                                
  3868.                                                                                
  3869. - Special keys for 'moving around' the BROWSE screen are:                      
  3870.                                                                                
  3871.     Left Arrow Key      - Move to next field to your left                      
  3872.     Right Arrow Key     - Move to next field to your right                     
  3873.     Ctrl Home           - Go to the leftmost field                             
  3874.     Ctrl End            - Go to the rightmost field (on the end of the record) 
  3875.     Up Arrow            - Move highlight to the previous record                
  3876.     Down Arrow          - Move highlight to the next record                    
  3877.     PgUp                - Page up a full screen of records                     
  3878.     PgDn                - Page down a full screen of records                   
  3879.     Ctrl PgUp           - Go to the beginning of the file                      
  3880.     Ctrl PgDn           - Go to the end or last record of the file             
  3881.     Ctrl N              - Add a record (where applicable)                      
  3882.     Ctrl U              - Delete a record (where applicable)                   
  3883.     F5                  - To seek/find a record based upon the active index    
  3884.     Esc                 - Exit the current operation                           
  3885.                                                                                
  3886.                                                                                
  3887.  - Remember that there are many more fields to the right of the screen. Press  
  3888.    the right arrow key to view them...                                         
  3889.    DAYO Smart Reports,    TJS LAB                                    Page: 54
  3890.                                                                                
  3891.                                                                                
  3892.                                                                                
  3893.  ■ COPY (.DBF) TO                                                              
  3894.                                                                                
  3895.  - Copy records to another (new) database. Use this option to copy select      
  3896.    records into a new database or ASCII (SDF and DELIMITED) file. COPY TO can  
  3897.    also be used to create backups of data (EG: copy to floppy).                
  3898.                                                                                
  3899.  ┌─────────────────────────────[ COPY (.DBF) TO ]─────────────────────────────┐
  3900.  │                                                                            │
  3901.  │   Enter Database Name To COPY FROM:                                        │
  3902.  │   Enter┌────────[ PICK A DATABASE ]───────────┐y...                        │
  3903.  │        │ FILE NAME      SIZE         DATE USED│                            │
  3904.  │        ├──────────────┬────────────┬──────────┤                            │
  3905.  │        │HARPS.DBF     │        375 │ 09/16/89 │                            │
  3906.  │        │INVENT.DBF    │       7335 │ 09/16/89 │                            │
  3907.  │        │SDFSTUF.DBF   │        103 │ 09/16/89 │                            │
  3908.  │        │MORETRAH.DBF  │      24387 │ 09/16/89 │                            │
  3909.  │        │AP.DBF        │        289 │ 09/16/89 │                            │
  3910.  │        └──────────────┴────────────┴──────────┘                            │
  3911.  │                                                   ┌───────────────────────┐│
  3912.  │                                                   │ Highlight a database  ││
  3913.  │                                                   │ using the             ││
  3914.  │                                                   │ arrow keys, then press││
  3915.  │                                                   │ Enter/Return.         ││
  3916.  │                                                   └───────────────────────┘│
  3917.  └────────────────────────────────────────────────────────────────────────────┘
  3918.                                                                                
  3919.                                                                                
  3920.  - The next prompt will be to select the type of COPY TO option you want:      
  3921.                                                                                
  3922.                                                                                
  3923.  ┌──────────────────────────────[ COPY (.DBF) TO ]────────────────────────────┐
  3924.  │                                                                            │
  3925.  │    Enter Database Name To COPY FROM: INVENT.DBF                            │
  3926.  │    Enter Nothing For Listing Of Current Directory...                       │
  3927.  │                                                                            │
  3928.  │                                                                            │
  3929.  │    Type of Copy To:    Standard     SDF     DELIMITED     STRUCTURE        │
  3930.  │                                                                            │
  3931.  │                                                                            │
  3932.  │    Copy Records From INVENT.DBF                                            │
  3933.  └────────────────────────────────────────────────────────────────────────────┘
  3934.                                                                                
  3935.                                                                                
  3936.  - The Standard option is simply creating another database (.DBF). The SDF and 
  3937.    DELIMITED options will create ASCII files. The STRUCTURE option creates a   
  3938.    new database with the same file structure as the initial database (no       
  3939.    records copied).                                                            
  3940.    DAYO Smart Reports,    TJS LAB                                    Page: 55
  3941.                                                                                
  3942.                                                                                
  3943.                                                                                
  3944.  - The next prompt (optional), requires some knowledge of dBase (tm). This
  3945.    prompt is requesting the user to to enter a condition or filter. If all
  3946.    records are to be copied, just press Enter on an empty prompt.
  3947.  
  3948.                                                                                
  3949.  ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
  3950.  │║                                                                          ║│
  3951.  │║PART{C}  ■ MFG_PART{C}  ■ DESC{C}  ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■   ║│
  3952.  │║NOTES{M} ■                                                                ║│
  3953.  │╚══════════════════════════════════════════════════════════════════════════╝│
  3954.  │                                                                            │
  3955.  │                                                                            │
  3956.  │    Type of Copy To:    Standard     SDF     DELIMITED     STRUCTURE        │
  3957.  │                                                                            │
  3958.  │    Enter SDF File Name To Copy Data TO:  NEW.DBF                           │
  3959.  │                                                                            │
  3960.  │    Enter Condition:                                                        │
  3961.  │    Sample condition:   COST > 100                                          │
  3962.  │                                                                            │
  3963.  │                                                                            │
  3964.  │    Copy Records From NEW                                                   │
  3965.  └────────────────────────────────────────────────────────────────────────────┘
  3966.                                                                                
  3967.                                                                                
  3968.  - This 'Condition' option is useful for coping only specific records into a   
  3969.    new location. Any valid dBase/Clipper statement (as shown next) is          
  3970.    fine...                                                                     
  3971.                                                                                
  3972.                                                                                
  3973.  ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
  3974.  │║                                                                          ║│
  3975.  │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■      ║│
  3976.  │║NOTES{M} ■                                                                ║│
  3977.  │╚══════════════════════════════════════════════════════════════════════════╝│
  3978.  │                                                                            │
  3979.  │    Type of Copy To:    Standard     SDF     DELIMITED     STRUCTURE        │
  3980.  │                                                                            │
  3981.  │    Enter SDF File Name To Copy Data TO:  NEW DBF                           │
  3982.  │                                                                            │
  3983.  │    Enter Condition:  PRICE>0                                               │
  3984.  │    Sample condition:   COST > 100                                          │
  3985.  │                                                                            │
  3986.  │    Copy Records From NEW                                                   │
  3987.  └────────────────────────────────────────────────────────────────────────────┘
  3988.    DAYO Smart Reports,    TJS LAB                                    Page: 56
  3989.                                                                                
  3990.                                                                                
  3991.                                                                                
  3992.  - The following window message will appear while the COPY TO routine does     
  3993.    its task:                                                                   
  3994.                                                                                
  3995.  ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
  3996.  │║                                                                          ║│
  3997.  │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■      ║│
  3998.  │║NOTES{M} ■                                                                ║│
  3999.  │╚══════════════════════════════════════════════════════════════════════════╝│
  4000.  │                                                                            │
  4001.  │    Type of Copy To:    Standard     SDF     DELIMITED     STRUCTURE        │
  4002.  │                                                                            │
  4003.  │    Enter SDF File Name To Copy Data TO:  NEW10                             │
  4004.  │                                                                            │
  4005.  │    Enter Condition:  PRICE>0                                               │
  4006.  │    Sample cond┌───────────────────────────────────────────────┐            │
  4007.  │               │┌─────────────────────────────────────────────┐│            │
  4008.  │    CONDITION: ││┌───────────────────────────────────────────┐││            │
  4009.  │               │││┌─────────────────────────────────────────┐│││            │
  4010.  │               ││││Hold those camels while I do this COPY TO││││            │
  4011.  │               │││└─────────────────────────────────────────┘│││            │
  4012.  │               ││└───────────────────────────────────────────┘││            │
  4013.  │               │└─────────────────────────────────────────────┘│            │
  4014.  │               └───────────────────────────────────────────────┘            │
  4015.  │    Copy Records From SDF  To NEW10                                         │
  4016.  └────────────────────────────────────────────────────────────────────────────┘
  4017.                                                                                
  4018.                                                                                
  4019.                                                                                
  4020.  ■ CREATE DATABASE                                                             
  4021.                                                                                
  4022.  - Create a new database. This routine lets you create entirely new database   
  4023.    structures. At the FIELD_NAME field, enter a unique field name. At the      
  4024.    FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date, 
  4025.    'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the     
  4026.    size/length of the character and/or numeric field. At the FIELD_DEC field,  
  4027.    enter the number of decimals for the numeric field.                         
  4028.                                                                                
  4029.                                                                                
  4030.                ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐             
  4031.                │ FIELD_NAME   FIELD_TYPE   FIELD_LEN   FIELD_DEC │             
  4032.                │────────────╥────────────╥───────────╥───────────│             
  4033.                │            ║            ║         0 ║         0 │             
  4034.                │            ║            ║           ║           │             
  4035.                │            ║            ║           ║           │             
  4036.  ┌─────────────│            ║            ║           ║           │────────────┐
  4037.  │             │            ║            ║           ║           │            │
  4038.  │     ENTER TH│            ║            ║           ║           │            │
  4039.  │             │            ║            ║           ║           │            │
  4040.  └─────────────│            ║            ║           ║           │────────────┘
  4041.                │────────────╨────────────╨───────────╨───────────│             
  4042.                │        Press Enter to edit any field...         │             
  4043.                └──────[ PRESS  Ctrl W  TO SAVE AND EXIT ]────────┘             
  4044.    DAYO Smart Reports,    TJS LAB                                    Page: 57
  4045.                                                                                
  4046.                                                                                
  4047.                                                                                
  4048.    * * *    TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST * * *                
  4049.             IT IS SLIGHTLY BOTHERSOME                                          
  4050.             SORRY!  WANT YOU TO THINK ABOUT WHAT YOU ARE DOING...              
  4051.                                                                                
  4052.                                                                                
  4053.                                                                                
  4054.    *** If any error is made in this routine, you will experience an            
  4055.    error, either immediately, or when you start to edit the new database.      
  4056.    This error may even cause your computer to hang!                            
  4057.                                                                                
  4058.                                                                                
  4059.                                                                                
  4060.    *** Be sure to Press:  Ctrl W  when you are finished and                    
  4061.    satisfied. Pressing  Esc  will just negate your efforts..                   
  4062.                                                                                
  4063.                                                                                
  4064.                                                                                
  4065.                ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐             
  4066.                │ FIELD_NAME   FIELD_TYPE   FIELD_LEN   FIELD_DEC │             
  4067.                │────────────╥────────────╥───────────╥───────────│             
  4068.                │ NAME       ║ C          ║        30 ║         0 │             
  4069.                │ AGE        ║ N          ║         5 ║         1 │             
  4070.                │ DEAD       ║ L          ║         1 ║         0 │             
  4071.                │ BIRTHDATE  ║ D          ║         8 ║         0 │             
  4072.  ┌─────────────│ REMARKS    ║ M          ║        10 ║         0 │────────────┐
  4073.  │             │            ║            ║         0 ║         0 │            │
  4074.  │     ENTER TH│            ║            ║           ║           │            │
  4075.  │             │            ║            ║           ║           │            │
  4076.  │             │            ║            ║           ║           │            │
  4077.  └─────────────│            ║            ║           ║           │────────────┘
  4078.                │            ║            ║           ║           │             
  4079.                │────────────╨────────────╨───────────╨───────────│             
  4080.                │        Press Enter to edit any field...         │             
  4081.                └──────[ PRESS  Ctrl W  TO SAVE AND EXIT ]────────┘             
  4082.    DAYO Smart Reports,    TJS LAB                                    Page: 58
  4083.                                                                                
  4084.                                                                                
  4085.                                                                                
  4086.  ■ DELETE RECORDS                                                              
  4087.                                                                                
  4088.  - Delete selected records from databases. The first prompt is for the name of 
  4089.    the database you wish to mark records for deletion. Like many of the other  
  4090.    routines, you can press enter on an empty prompt to bring up all databases  
  4091.    that exist in the current directory:                                        
  4092.                                                                                
  4093.                                                                                
  4094.           ┌────────[ PICK A DATABASE ]───────────┐                             
  4095.           │ FILE NAME      SIZE         DATE USED│                             
  4096.           ├──────────────┬────────────┬──────────┤                             
  4097.           │D.DBF         │        259 │ 09/16/89 │                             
  4098.           │DDD.DBF       │        375 │ 09/16/89 │                             
  4099.           │NEW.DBF       │        195 │ 09/17/89 │                             
  4100.           │SDF.DBF       │       7335 │ 09/16/89 │                             
  4101.           │TRASH.DBF     │      24387 │ 09/16/89 │                             
  4102.           │XXX.DBF       │        289 │ 09/16/89 │   ┌────────────────────────┐
  4103.           └──────────────┴────────────┴──────────┘   │ Highlight a database   │
  4104.                                                      │ using the              │
  4105.  ┌────────────────────────[ DELETE SELECTED RECORDS ]│ arrow keys, then press │
  4106.  │   Enter Database Name:                            │ Enter/Return.          │
  4107.  │                                                   └────────────────────────┘
  4108.  │                                                                            │
  4109.  └────────────────────────────────────────────────────────────────────────────┘
  4110.                                                                                
  4111.                                                                                
  4112.  - After selecting the database, all its fields will be presented atop the     
  4113.    screen so as to aid the user in entering a condition/filter. The use of the 
  4114.    condition prompt is NOT optional, so some knowledge of dBase/Clipper syntax 
  4115.    is required. Note the use of the Clipper Function: EMPTY().                 
  4116.                                                                                
  4117.                                                                                
  4118.  ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
  4119.  │║                                                                           ║
  4120.  ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■       ║
  4121.   ║NOTES{M} ■                                                                 ║
  4122.   ╚═══════════════════════════════════════════════════════════════════════════╝
  4123.                                                                                
  4124.                                                                                
  4125.                                                                                
  4126.  ┌────────────────────────[ DELETE SELECTED RECORDS ]─────────────────────────┐
  4127.  │   Enter Database Name: TRASH                                               │
  4128.  │   Delete Records For Condition:  EMPTY(PART)                               │
  4129.  │   Sample condition:   COST > 100                                           │
  4130.  │   CONDITION: EMPTY(PART)                                                   │
  4131.  │   Number of Records Deleted:        208                                    │
  4132.  │                        Press any key to continue...                        │
  4133.  └────────────────────────────────────────────────────────────────────────────┘
  4134.                                                                                
  4135.  - The number of records deleted will be displayed upon the screen as depicted 
  4136.    just above...                                                               
  4137.    DAYO Smart Reports,    TJS LAB                                    Page: 59
  4138.                                                                                
  4139.                                                                                
  4140.                                                                                
  4141.  ■ ERASE FILE                                                                  
  4142.                                                                                
  4143.  - Erase a file (forever!).       Use this option with extreme care!           
  4144.                                                                                
  4145.    Again, be careful! ANY FILE SELECTED WITH THIS OPTION WILL BE PERMANENTLY   
  4146.    REMOVED FROM EXISTENCE                                                      
  4147.                                                                                
  4148.    NO SECOND CHANCES HERE...                                                   
  4149.                                                                                
  4150.  - The first prompt is for the file name. You can press enter on an empty      
  4151.    prompt to bring up a window selection of all files in the current directory.
  4152.                                                                                
  4153.                                                      ┌────────────────────────┐
  4154.           ┌────────[ ERASE THE FILE ]────────────┐   │ Highlight a file       │
  4155.           │ FILE NAME      SIZE         DATE USED│   │ using the              │
  4156.           ├──────────────┬────────────┬──────────┤   │ arrow keys, then press │
  4157.           │B.BAT         │        222 │ 09/16/89 │   │ Enter/Return.          │
  4158.           │BKDOOR.$$$    │       8192 │ 09/16/89 │   └────────────────────────┘
  4159.           │BKDOOR.DOC    │      37029 │ 09/17/89 │                             
  4160.           │BKDOOR.ZIP    │      19415 │ 09/16/89 │                             
  4161.           │D.DBF         │        259 │ 09/16/89 │                             
  4162.           │D.DBT         │        512 │ 09/16/89 │                             
  4163.           │DAYOBK.BAK    │      36879 │ 09/16/89 │                             
  4164.           │DAYOBK.LIB    │      36879 │ 09/16/89 │                             
  4165.           │DAYOBK.LST    │       2056 │ 09/16/89 │                             
  4166.           │DAYOBK.OBJ    │      35585 │ 09/16/89 │                             
  4167.           │DAYOCAL.MAP   │         35 │ 09/16/89 │                             
  4168.           │DDD.DBF       │        375 │ 09/16/89 │                             
  4169.           │DDD.DBT       │        512 │ 09/16/89 │                             
  4170.           │DDD.NTX       │       2048 │ 09/16/89 │                             
  4171.           │DEMO.EXE      │     245404 │ 09/16/89 │                             
  4172.           └──────────────┴────────────┴──────────┘  More                       
  4173.                                                                                
  4174.  - To ERASE a file, just highlight it, then press Enter...                     
  4175.                                                                                
  4176.                                                                                
  4177.                                                                                
  4178.  ■ EXIT TO DOS
  4179.                                                                                
  4180.  - This option will close all open files and databases and exit to DOS without 
  4181.    having to return to the main menu exit routine.                             
  4182.    DAYO Smart Reports,    TJS LAB                                    Page: 60
  4183.                                                                                
  4184.                                                                                
  4185.                                                                                
  4186.  ■ INDEX A DATABASE                                                            
  4187.                                                                                
  4188.  - You will be prompted to select the database you wish to index. After        
  4189.    selecting the database, by typing in the name or pressing Enter on an empty 
  4190.    prompt (then selecting from the window), you will be given a listing of all 
  4191.    fields in that database atop the screen.                                    
  4192.                                                                                
  4193.                                                                                
  4194.           ┌────────[ PICK A DATABASE ]───────────┐.                            
  4195.           │ FILE NAME      SIZE         DATE USED│                             
  4196.           ├──────────────┬────────────┬──────────┤                             
  4197.           │DAD.DBF       │        259 │ 09/16/89 │                             
  4198.           │NEW.DBF       │        195 │ 09/17/89 │                             
  4199.           │SPW.DBF       │       7335 │ 09/16/89 │                             
  4200.           │SOW.DBF       │        103 │ 09/16/89 │                             
  4201.           │BOY.DBF       │      24387 │ 09/17/89 │                             
  4202.           │SHI.DBF       │        289 │ 09/16/89 │   ┌────────────────────────┐
  4203.           └──────────────┴────────────┴──────────┘   │ Highlight a database   │
  4204.                                                      │ using the              │
  4205.           ┌───────────────────[ INDEX A DATABASE ]───│ arrow keys, then press │
  4206.           │ Enter Database Name:                     │ Enter/Return.          │
  4207.           │                                          └────────────────────────┘
  4208.           └───────────────────────────────────────────────────────────────┘    
  4209.                                                                                
  4210.                                                                                
  4211.  - You will now be prompted to enter the name of the Index File. It will be    
  4212.    (by default), named exactly the same as the selected database, with the     
  4213.    exception of the extension. This will default to .NDX or .NTX depending on  
  4214.    whether you linked NDX.OBJ with your application.                           
  4215.                                                                                
  4216.                                                                                
  4217.   *** Remember that the BROWSE routine only looks at indexes with the same     
  4218.       name as the database.                                                    
  4219.                                                                                
  4220.                                                                                
  4221.  ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
  4222.  │║                                                                           ║
  4223.  ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■       ║
  4224.   ║NOTES{M} ■                                                                 ║
  4225.   ╚═══════════════════════════════════════════════════════════════════════════╝
  4226.                                                                                
  4227.                                                                                
  4228.           ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐    
  4229.           │ Enter Name of Index File:  TRASH.NTX                          │    
  4230.           └───────────────────────────────────────────────────────────────┘    
  4231.    DAYO Smart Reports,    TJS LAB                                    Page: 61
  4232.                                                                                
  4233.                                                                                
  4234.                                                                                
  4235.  - At the prompt for the index key, enter a field name, or a valid             
  4236.    dBase/Clipper expression.                                                   
  4237.                                                                                
  4238.  ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
  4239.  │║                                                                           ║
  4240.  ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■       ║
  4241.   ║NOTES{M} ■                                                                 ║
  4242.   ╚═══════════════════════════════════════════════════════════════════════════╝
  4243.                                                                                
  4244.                                                                                
  4245.                                                                                
  4246.                                                                                
  4247.           ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐    
  4248.           │ Enter Name of Index File:  TRASH.NTX                          │    
  4249.           │ Enter the Key Expression:  PART+MFG_PART                      │    
  4250.           └───────────────────────────────────────────────────────────────┘    
  4251.                                                                                
  4252.                                                                                
  4253.                                                                                
  4254.  ■ LIST FIELDS                                                                 
  4255.                                                                                
  4256.  - List fields to screen or printer. This routine is a great tool for providing
  4257.    simple reports and lists. The first prompt will be for the database you wish
  4258.    to work with. Type the name of the file, or press Enter on an empty prompt  
  4259.    to bring up a window of all databases in the current directory for          
  4260.    selection.                                                                  
  4261.                                                                                
  4262.                                                                                
  4263.           ┌────────[ PICK A DATABASE ]───────────┐                             
  4264.           │ FILE NAME      SIZE         DATE USED│                             
  4265.           ├──────────────┬────────────┬──────────┤                             
  4266.           │INVEND.DBF    │        259 │ 09/16/89 │                             
  4267.           │INVENT.DBF    │        375 │ 09/16/89 │                             
  4268.           │NEW.DBF       │        195 │ 09/17/89 │                             
  4269.           │SOMEDAY.DBF   │       7335 │ 09/16/89 │                             
  4270.           │TANGO.DBF     │        103 │ 09/16/89 │                             
  4271.           │AP.DBF        │      24387 │ 09/17/89 │                             
  4272.           │BACKUP.DBF    │        289 │ 09/16/89 │   ┌────────────────────────┐
  4273.           └──────────────┴────────────┴──────────┘   │ Highlight a database   │
  4274.                                                      │ using the              │
  4275.           ┌──────────────────────────────────────────│ arrow keys, then press │
  4276.           │ Enter Database Name:                     │ Enter/Return.          │
  4277.           │                                          └────────────────────────┘
  4278.           └───────────────────────────────────────────────────────────────┘    
  4279.    DAYO Smart Reports,    TJS LAB                                    Page: 62
  4280.                                                                                
  4281.                                                                                
  4282.                                                                                
  4283.  - The next prompt is for a condition or filter. This makes it possible to list
  4284.    only specific records that meet that condition you enter. The condition must
  4285.    be a valid dBase/Clipper expression, or none (to list all).                 
  4286.                                                                                
  4287.                                                                                
  4288.  ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
  4289.  │║                                                                           ║
  4290.  ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■       ║
  4291.   ║NOTES{M} ■                                                                 ║
  4292.   ╚═══════════════════════════════════════════════════════════════════════════╝
  4293.                                                                                
  4294.                                                                                
  4295.                         ┌─────────────────────────────────────────────────────┐
  4296.                         │ Enter Filter:                                       │
  4297.                         │ EG:  ID = "SAM0909" .AND. RETAIL > 10000            │
  4298.                         └─────────────────────────────────────────────────────┘
  4299.           ┌───────────────────────────────────────────────────────────────┐    
  4300.           │ Enter Database Name:                                          │    
  4301.           │                                                               │    
  4302.           └───────────────────────────────────────────────────────────────┘    
  4303.                                                                                
  4304.                                                                                
  4305.  - A window box appears next displaying all the fields in the selected database
  4306.    and an option to list all fields. Highlight any combination of fields ( or  
  4307.    ALL) that you want listed.                                                  
  4308.                                                                                
  4309.                                                                                
  4310.  ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
  4311.  │║ │ PICK THE FIELDS │                                                       ║
  4312.  ╘║P│ YOU WANT LISTED │} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■       ║
  4313.   ║ ├─────────────────┤                                                       ║
  4314.   ╚═│■■ ALL ■■        │═══════════════════════════════════════════════════════╝
  4315.     │RECNO()          │                                                        
  4316.     │MFG_PART         │                                                        
  4317.     │PRICE            │                                                        
  4318.     │YOURPART         │  ┌────────────────────────────────────────────────────┐
  4319.     │NOTES            │  │ Enter Filter:                                      │
  4320.     ├─────────────────┤  │ EG:  ID = "SAM0909" .AND. RETAIL > 10000           │
  4321.     │PRESS Esc TO EXIT│  └────────────────────────────────────────────────────┘
  4322.     └─────────────────┘────────────────────────────────────────────────────┐   
  4323.            │ Enter Database Name:                                          │   
  4324.            └───────────────────────────────────────────────────────────────┘   
  4325.    DAYO Smart Reports,    TJS LAB                                    Page: 63
  4326.                                                                                
  4327.                                                                                
  4328.                                                                                
  4329.  - The fields you select will be displayed at center top of screen. Press Esc  
  4330.    to exit the "PICK THE FIELDS YOU WANT LISTED" window.                       
  4331.                                                                                
  4332.                                                                                
  4333.  ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
  4334.  │║ │ PICK THE FIELDS │                                                       ║
  4335.  ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■       ║
  4336.   ║N├─────────────────┤       │PART                │                          ║
  4337.   ╚═│■■ ALL ■■        │═══════│MFG_PART            │══════════════════════════╝
  4338.     │RECNO()          │       │PRICE               │                           
  4339.     │PART             │       └────────────────────┘                           
  4340.     │PRICE            │                                                        
  4341.     │YOURPART         │  ┌────────────────────────────────────────────────────┐
  4342.     │NOTES            │  │ Enter Filter:                                      │
  4343.     ├─────────────────┤  │ EG:  ID = "SAM0909" .AND. RETAIL > 10000           │
  4344.     │PRESS Esc TO EXIT│  └────────────────────────────────────────────────────┘
  4345.     └─────────────────┘────────────────────────────────────────────────────┐   
  4346.            │ Enter Database Name:                                          │   
  4347.            └───────────────────────────────────────────────────────────────┘   
  4348.                                                                                
  4349.                                                                                
  4350.  - At the next prompt, you can send the list to the SCREEN, PRINTER OR         
  4351.    FILE.                                                                       
  4352.                                                                                
  4353.                                                                                
  4354.  ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
  4355.  │║ │ PICK THE FIELDS │                                                       ║
  4356.  ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■       ║
  4357.   ║N├─────────────────┤       │PART                │                          ║
  4358.   ╚═│■■ ALL ■■        │═══════│MFG_PART            │══════════════════════════╝
  4359.     │RECNO()          │       │PRICE               │                           
  4360.     │PART             │       └────────────────────┘                           
  4361.     │DESC┌──────────────────────────────────────────────────────────────────┐  
  4362.     │PRIC│ Do you want to print the list to the SCREEN or PAPER or FILE ?   │  
  4363.     │LIST│                                                                  │  
  4364.     │YOUR└──────────────────────────────────────────────────────────────────┘─┐
  4365.     │NOTES            │  │ Enter Filter:                                      │
  4366.     ├─────────────────┤  │ EG:  ID = "SAM0909" .AND. RETAIL > 10000           │
  4367.     │PRESS Esc TO EXIT│  └────────────────────────────────────────────────────┘
  4368.     └─────────────────┘────────────────────────────────────────────────────┐   
  4369.            │ Enter Database Name:                                          │   
  4370.            └───────────────────────────────────────────────────────────────┘   
  4371.    DAYO Smart Reports,    TJS LAB                                    Page: 64
  4372.                                                                                
  4373.                                                                                
  4374.                                                                                
  4375.  - The list is very simple, and if displayed onto the screen, may look like the
  4376.    following:                                                                  
  4377.                                                                                
  4378.  PART                         MFG_PART    PRICE                                
  4379.  4523                                        0.00                              
  4380.  DAYO9S                         41926     1904.34                              
  4381.  DAYO10S                        13564      616.11                              
  4382.  DAYOCOMP                       45625     2072.37                              
  4383.  DAYOALLS                       43159     1960.35                              
  4384.  INDEXER                        50558     2296.41                              
  4385.  INDEXERS                       51791     2352.42                              
  4386.  5  DEMO                         4932      224.04                              
  4387.  DAYO13S                        20963      952.17                              
  4388.  MENUS                          53024     2408.43                              
  4389.  OFFSITEP                       56724     2576.46                              
  4390.  ONSITEP                        57957     2632.47                              
  4391.  DAYO2S                         24662     1120.20                              
  4392.  DAYO9                          40693     1848.33                              
  4393.  DAYO10                         12331      560.10                              
  4394.  DAYOCAL$                       44392     2016.36                              
  4395.  DAYO13                         19730      896.16                              
  4396.  DAYO2                          23429     1064.19                              
  4397.  DAYO11                         14797      672.12                              
  4398.  DAYO8                          38227     1736.31                              
  4399.  DAYO1                          11098      504.09                              
  4400.  DAYO12                         17264      784.14                              
  4401.  DAYO5                          30828     1400.25                              
  4402.                       ......PRESS ANY KEY TO CONTINUE......                    
  4403.                                                                                
  4404.                                                                                
  4405.                                                                                
  4406.  ■ MODIFY DATABASE                                                             
  4407.                                                                                
  4408.  - Change the fields/structure of a database. You can add new fields, delete   
  4409.    fields, change the length and type of field in any of the databases. At the 
  4410.    FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter 
  4411.    a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M'  
  4412.    for memofield. At the FIELD_LEN field, enter the size/length of the         
  4413.    character and/or numeric field. At the FIELD_DEC field, enter the number of 
  4414.    decimals for the numeric field.                                             
  4415.                                                                                
  4416.                                                                                
  4417.    ********************************************************                    
  4418.    ***    TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST ***                    
  4419.    ***    IT IS SLIGHTLY BOTHERSOME SORRY!              ***
  4420.    ********************************************************                    
  4421.                                                                                
  4422.                                                                                
  4423.    *** If any error is made in this routine, you will experience an            
  4424.    error, either immediately, or when you start to access the database.        
  4425.    This error may even cause your computer to hang!                            
  4426.    DAYO Smart Reports,    TJS LAB                                    Page: 65
  4427.                                                                                
  4428.                                                                                
  4429.                                                                                
  4430.    *** Be sure to Press:  Ctrl W  when you are finished and                    
  4431.    satisfied. Pressing  Esc  will just negate your efforts..                   
  4432.                                                                                
  4433.                                                                                
  4434.                                                                                
  4435.  ■ PACK DATABASE                                                               
  4436.                                                                                
  4437.  - Pack a database (removed deleted records). This option will permanently     
  4438.    remove any records marked for deletion. This is another routine you should  
  4439.    use with great care! As in many of the other of the routines, you will be   
  4440.    prompted to enter the name of the database you wish to pack. Enter the name 
  4441.    or press Enter on an empty prompt to view the window.                       
  4442.                                                                                
  4443.                                                                                
  4444.                     ┌─────┐                                                    
  4445.                     │PACK!│                                                    
  4446.                     └─────┘                                                    
  4447.                                                                                
  4448.           ┌────────[ PICK A DATABASE ]───────────┐                             
  4449.           │ FILE NAME      SIZE         DATE USED│                             
  4450.           ├──────────────┬────────────┬──────────┤                             
  4451.           │GOODDATA.DBF  │        259 │ 09/16/89 │                             
  4452.           │HAP.DBF       │        375 │ 09/16/89 │                             
  4453.           │NEW.DBF       │        195 │ 09/17/89 │                             
  4454.           │SDF.DBF       │       7335 │ 09/16/89 │                             
  4455.           │LOIN.DBF      │        103 │ 09/16/89 │                             
  4456.           │TRASH.DBF     │      24387 │ 09/17/89 │                             
  4457.           │FIX.DBF       │        289 │ 09/16/89 │   ┌────────────────────────┐
  4458.           └──────────────┴────────────┴──────────┘   │ Highlight a database   │
  4459.                                                      │ using the              │
  4460.           ┌──────────────────────────────────────────│ arrow keys, then press │
  4461.           │ Enter Database Name:                     │ Enter/Return.          │
  4462.           └──────────────────────────────────────────└────────────────────────┘
  4463.                                                                                
  4464.                                                                                
  4465.  - After selecting the database, you will be prompted to respond with a Yes or 
  4466.    No (to Pack or not to Pack...). This is the last chance you have to change  
  4467.    your mind...                                                                
  4468.                                                                                
  4469.   ┌──────────────────────────────────────────────────────────────────────────┐ 
  4470.   │                           PACK TOM3                                      │ 
  4471.   │ Are you sure you want to PACK (remove deleted records) ?   N             │ 
  4472.   └──────────────────────────────────────────────────────────────────────────┘ 
  4473.           │ Enter Database Name:                                          │    
  4474.           └───────────────────────────────────────────────────────────────┘    
  4475.    DAYO Smart Reports,    TJS LAB                                    Page: 66
  4476.                                                                                
  4477.                                                                                
  4478.                                                                                
  4479.  ■ RECALL RECORDS                                                              
  4480.                                                                                
  4481.  - Recalls records previously marked for deletion. This option is identical to 
  4482.    the DELETE RECORDS option discussed earlier...                              
  4483.                                                                                
  4484.                                                                                
  4485.                                                                                
  4486.  ■ RETURN TO MENU                                                              
  4487.                                                                                
  4488.  - Returns to the procedure that called MISC Routines.                         
  4489.                                                                                
  4490.                                                                                
  4491.                                                                                
  4492.  ■ RUN (DOS COMMAND)                                                           
  4493.                                                                                
  4494.  - Run a DOS command  (EG: dir/w). This option is helpful in that it allows    
  4495.    you to run programs at the DOS level (within memory constraints).           
  4496.                                                                                
  4497.                                                                                
  4498.  ┌───────────────────────────────────────────────────────────────────────────┐ 
  4499.  │ RUN  CD\DOS                                                               │ 
  4500.  └───────────────────────────────────────────────────────────────────────────┘ 
  4501.                                                                                
  4502.                                                                                
  4503.  - One useful option is to type and Enter: COMMAND at this prompt. You will be 
  4504.    running another DOS Shell totally out of the program (it still is in memory 
  4505.    though).                                                                    
  4506.                                                                                
  4507.                                                                                
  4508.  ┌───────────────────────────────────────────────────────────────────────────┐ 
  4509.  │ RUN  COMMAND                                                              │ 
  4510.  └───────────────────────────────────────────────────────────────────────────┘ 
  4511.                                                                                
  4512.                                                                                
  4513.  - Press and Enter: EXIT to return to your Clipper Application.                
  4514.                                                                                
  4515.  EG:                                                                           
  4516.                                                                                
  4517.  The COMPAQ Personal Computer MS-DOS                                           
  4518.  Version 3.31                                                                  
  4519.                                                                                
  4520.  (C) Copyright Compaq Computer Corp. 1982, 1987                                
  4521.  (C) Copyright Microsoft Corp. 1981, 1987                                      
  4522.                                                                                
  4523.  C:\KISBBS>EXIT                                                                
  4524.    DAYO Smart Reports,    TJS LAB                                    Page: 67
  4525.                                                                                
  4526.                                                                                
  4527.                                                                                
  4528.  ■ SIMPLE EDITOR                                                               
  4529.                                                                                
  4530.  - A simple editor and word processor. Use this option to create and read      
  4531.    simple TEXT files. File size is limited to your machines capabilities or    
  4532.    32,000k. The first prompt is for the name of the file you wish to edit. Type
  4533.    in the name, or press Enter on an empty prompt to bring up a window option  
  4534.    box containing all files in the current directory.
  4535.                                                                                
  4536.                                                                                
  4537.                                                      ┌────────────────────────┐
  4538.           ┌──────────[ EDIT THE FILE ]───────────┐   │ Highlight a file       │
  4539.           │ FILE NAME      SIZE         DATE USED│   │ using the              │
  4540.           ├──────────────┬────────────┬──────────┤   │ arrow keys, then press │
  4541.           │B.BAT         │        222 │ 09/16/89 │   │ Enter/Return.          │
  4542.           │BKDOOR.DOC    │      56356 │ 09/17/89 │   └────────────────────────┘
  4543.           │BKDOOR.ZIP    │      19415 │ 09/16/89 │                             
  4544.           │DAYOBK.LIB    │      36879 │ 09/16/89 │                             
  4545.           │DAYOBK.LST    │       2056 │ 09/16/89 │                             
  4546.  ┌────────│DAYOBK.OBJ    │      35585 │ 09/16/89 │────────────────────────────┐
  4547.  │ Enter t│DAYOCAL.MAP   │         35 │ 09/16/89 │                            │
  4548.  │ Press E│DDD.DBF       │        375 │ 09/16/89 │urrent directory listing.   │
  4549.  └────────│DDD.DBT       │        512 │ 09/16/89 │────────────────────────────┘
  4550.           │DDD.NTX       │       2048 │ 09/16/89 │                             
  4551.           │DEMO.EXE      │     245404 │ 09/16/89 │                             
  4552.           │DEMO.MAP      │       7780 │ 09/16/89 │                             
  4553.           └──────────────┴────────────┴──────────┘  More
  4554.                                                                                
  4555.                                                                                
  4556.  - *** Note, this routine will try to load binary files (.EXE, .OBJ, .etc...), 
  4557.    so be careful at what you select for viewing/editing.                       
  4558.                                                                                
  4559.                                                                                
  4560.  - If you make ANY changes to the file, You MUST PRESS  Ctrl W  to SAVE those  
  4561.    changes. If you exit with an  Esc, all changes will be lost!                
  4562.                                                                                
  4563.                                                                                
  4564.  ┌──────────────────────────────[ SIMPLE EDITOR ]─────────────────────────────┐
  4565.  │CLIPPER demo                                                                │
  4566.  │CLIPPER MISC                                                                │
  4567.  │KWAIT 10                                                                    │
  4568.  │LIB MISC-+MISC,MISC.LST,MISC                                                │
  4569.  │KWAIT 10                                                                    │
  4570.  │TLINK DEMO,,,MISC \CLIPPER\CLIPPER \CLIPPER\EXTEND                          │
  4571.  │KWAIT 10                                                                    │
  4572.  │DEMO                                                                        │
  4573.  └────────────────────────────────────────────────────────────────────────────┘
  4574.  Esc (ABORT)    Ctrl W (SAVE)                  Initial Size: 222  1/0          
  4575.    DAYO Smart Reports,    TJS LAB                                    Page: 68
  4576.                                                                                
  4577.                                                                                
  4578.                                                                                
  4579.  - Special keys for 'moving around' the SIMPLE EDITOR screen are:              
  4580.                                                                                
  4581.     Left Arrow Key      - Move to your left                                    
  4582.     Right Arrow Key     - Move to your right                                   
  4583.     Ctrl Home           - Go to the top, leftmost corner of window             
  4584.     Ctrl End            - Go to the bottom, rightmost corner of window         
  4585.     Up Arrow            - Move up one line                                     
  4586.     Down Arrow          - Move down one line                                   
  4587.     PgUp                - Page up a full screen                                
  4588.     PgDn                - Page down a full screen                              
  4589.     Ctrl PgUp           - Go to the beginning of the file                      
  4590.     Ctrl PgDn           - Go to the end of the file                            
  4591.  *  F2                  - Import text from a text file                         
  4592.  *  Ctrl W              - Save Changes and Exit                                
  4593.  *  Esc                 - ABORT Changes and Exit                               
  4594.                                                                                
  4595.                                                                                
  4596.    The margin may exceed the boundaries on the right side of the screen, but   
  4597.    the text is easily accessed using the special keys above...                 
  4598.                                                                                
  4599.                                                                                
  4600.                                                                                
  4601.  ■ SORT DATABASE                                                               
  4602.                                                                                
  4603.  - This option takes a database, sorts it, and copies the result into a new    
  4604.    database. The first prompt is for the name of the database you want to sort.
  4605.    Enter the name, or press Enter on an empty prompt to bring up a window box  
  4606.    containing all databases in the current directory.                          
  4607.                                                                                
  4608.                                                                                
  4609.           ┌────────[ PICK A DATABASE ]───────────┐                             
  4610.           │ FILE NAME      SIZE         DATE USED│                             
  4611.           ├──────────────┬────────────┬──────────┤                             
  4612.           │DOG.DBF       │        259 │ 09/16/89 │                             
  4613.           │CAT.DBF       │        375 │ 09/16/89 │                             
  4614.           │CAR.DBF       │        195 │ 09/17/89 │                             
  4615.           │BAM.DBF       │       7335 │ 09/16/89 │                             
  4616.           │HARP.DBF      │        103 │ 09/17/89 │                             
  4617.           │TRAIN.DBF     │      24387 │ 09/17/89 │                             
  4618.           │HIPPY.DBF     │        289 │ 09/16/89 │   ┌────────────────────────┐
  4619.           └──────────────┴────────────┴──────────┘   │ Highlight a database   │
  4620.                                                      │ using the              │
  4621.           ┌───────────────────[ SORT A DATABASE ]────│ arrow keys, then press │
  4622.           │ Enter Database Name:                     │ Enter/Return.          │
  4623.           │                                          └────────────────────────┘
  4624.           │                                                               │    
  4625.           └───────────────────────────────────────────────────────────────┘    
  4626.    DAYO Smart Reports,    TJS LAB                                    Page: 69
  4627.  
  4628.                                                                                
  4629.                                                                                
  4630.  - The next prompt is for the name of the database you will be creating with   
  4631.    the sorted data.                                                            
  4632.                                                                                
  4633.                                                                                
  4634.  ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
  4635.  │║                                                                           ║
  4636.  ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■       ║
  4637.   ║NOTES{M} ■                                                                 ║
  4638.   ╚═══════════════════════════════════════════════════════════════════════════╝
  4639.                                                                                
  4640.                                                                                
  4641.                                                                                
  4642.            ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐   
  4643.            │ Enter Database Name: INVNET.DBF                               │   
  4644.            │ Enter Name of Sorted File: INVNET1.DBF                        │   
  4645.            │                                                               │   
  4646.            └───────────────────────────────────────────────────────────────┘   
  4647.                                                                                
  4648.                                                                                
  4649.  - The next prompt is for the sort field (limited to 1 field)...               
  4650.                                                                                
  4651.                                                                                
  4652.  ╒╔═════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ 
  4653.  ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■      ║ 
  4654.   ║NOTES{M} ■                                                                ║ 
  4655.   ╚══════════════════════════════════════════════════════════════════════════╝ 
  4656.                                                                                
  4657.                                                                                
  4658.           ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐    
  4659.           │ Enter Database Name: TOM.DBF                                  │    
  4660.           │ Enter Name of Sorted File: TOM1.DBF                           │    
  4661.           │ Enter the Key Expression:  PART                               │    
  4662.           └───────────────────────────────────────────────────────────────┘    
  4663.                                                                                
  4664.                                                                                
  4665.                                                                                
  4666.  ■ TYPE (PRINT) FILE                                                           
  4667.                                                                                
  4668.  - Prints an ASCII/text file to screen or printer. The first prompt is for the 
  4669.    file name.                                                                  
  4670.                                                                                
  4671.                                                                                
  4672.  ┌───────────────────────[ TYPE TO SCREEN OR PRINTER ]────────────────────────┐
  4673.  │ Enter the ASCII/TEXT file to TYPE: KISBBS.DOC                              │
  4674.  │ Press Enter/Return on an empty field to get a current directory listing.   │
  4675.  └────────────────────────────────────────────────────────────────────────────┘
  4676.    DAYO Smart Reports,    TJS LAB                                    Page: 70
  4677.                                                                                
  4678.                                                                                
  4679.                                                                                
  4680.  - The display of the file (any type), is continuous, but can be paused by     
  4681.    any key (except the Enter & Esc keys). Pressing the Enter key will slow the 
  4682.    printing of the file onto the screen. Press Esc to Abort the display... A   
  4683.    sample display:                                                             
  4684.                                                                                
  4685.                                                                                
  4686.  FUNCKEY...........MISC              FUNIQUE...........MISC                    
  4687.  FZAP..............MISC              GET_PIC1..........MISC                    
  4688.  ISDATA............MISC              ISDBF.............MISC                    
  4689.  MENU_KEY..........MISC              MISC..............MISC                    
  4690.  OKFILE............MISC              PACKIT............MISC                    
  4691.  PICKDBF...........MISC              PROCLIST..........MISC                    
  4692.  SHOW_INS2.........MISC              STATLINE2.........MISC                    
  4693.  TOG_INS2..........MISC              XKEY_CLEAR........MISC                    
  4694.  XKEY_NORM.........MISC              XMEMO.............MISC                    
  4695.                                                                                
  4696.  MISC                                                                          
  4697.    BKDOOR            BROWSEIT          CENTER1           COLORSET              
  4698.    DBFUNCT           DBFUNCT6          EDITOR            FACHOICE              
  4699.    FAPPEND           FCOPY2            FDBF1             FDELETE               
  4700.    FERASE            FILESZ            FILE_UDF          FILT                  
  4701.    FINDER            FINDEX            FMAKEDB           FMODYDB               
  4702.    FNEW              FRECALL           FRUN              FSCROLL1              
  4703.    FSORT             FTYPEIT           FUNCKEY           FUNIQUE               
  4704.    FZAP              GET_PIC1          ISDATA            ISDBF                 
  4705.    MENU_KEY          MISC              OKFILE            PACKIT                
  4706.    PICKDBF           PROCLIST          SHOW_INS2         STATLINE2             
  4707.    TOG_INS2          XKEY_CLEAR        XKEY_NORM         XMEMO                 
  4708.                                                                                
  4709.  PRESS ANY KEY TO CONTINUE...                                                  
  4710.                                                                                
  4711.                                                                                
  4712.                                                                                
  4713.  ■ ZAP DATABASE                                                                
  4714.                                                                                
  4715.  - Totally erase all records in database (forever!). When you                  
  4716.    want to remove every record from a database, then use this option. Use with 
  4717.    EXTREME CAUTION! The first prompt is for the file name. Enter the name of   
  4718.    the database you are to 'clean out', or press Enter to select the database  
  4719.    from a window containing all databases in the current directory.            
  4720.    DAYO Smart Reports,    TJS LAB                                    Page: 71
  4721.                                                                                
  4722.                                                                                
  4723.                                                                                
  4724.                     ┌────┐                                                     
  4725.                     │ZAP!│                                                     
  4726.                     └────┘                                                     
  4727.                                                                                
  4728.                                                                                
  4729.           ┌────────[ PICK A DATABASE ]───────────┐                             
  4730.           │ FILE NAME      SIZE         DATE USED│                             
  4731.           ├──────────────┬────────────┬──────────┤                             
  4732.           │DENVER.DBF    │        259 │ 09/16/89 │                             
  4733.           │OHIO.DBF      │        375 │ 09/16/89 │                             
  4734.           │NEWYORK.DBF   │        195 │ 09/17/89 │                             
  4735.           │MONTANA.DBF   │       7335 │ 09/16/89 │                             
  4736.           │SC.DBF        │        259 │ 09/17/89 │                             
  4737.           │EARS.DBF      │        103 │ 09/17/89 │                             
  4738.           │FRUIT.DBF     │      24387 │ 09/17/89 │   ┌────────────────────────┐
  4739.           │MATH.DBF      │        259 │ 09/17/89 │   │ Highlight a database   │
  4740.           │CARROTS.DBF   │        289 │ 09/16/89 │   │ using the              │
  4741.           └──────────────┴────────────┴──────────┘───│ arrow keys, then press │
  4742.           │ Enter Database Name:                     │ Enter/Return.          │
  4743.           └──────────────────────────────────────────└────────────────────────┘
  4744.                                                                                
  4745.                                                                                
  4746.  - You will be prompted one last time as to whether you still want to ZAP the  
  4747.    selected database. Press Y for Yes, N for No...                             
  4748.                                                                                
  4749.                                                                                
  4750.                     ┌────┐                                                     
  4751.                     │ZAP!│                                                     
  4752.                     └────┘                                                     
  4753.                                                                                
  4754.                                                                                
  4755.   ┌──────────────────────────────────────────────────────────────────────────┐ 
  4756.   │                           ZAP TRASH                                      │ 
  4757.   │ Are you sure you want to ZAP (remove all records permanantly) ?   N      │ 
  4758.   │                                                                          │ 
  4759.   └──────────────────────────────────────────────────────────────────────────┘ 
  4760.           │ Enter Database Name:                                          │    
  4761.           └───────────────────────────────────────────────────────────────┘    
  4762.                                                                                
  4763.    DAYO Smart Reports,     TJS LAB                                   Page: 72
  4764.                                                                                
  4765.                                                                                
  4766.                                                                                
  4767.  ■ HELP SCREENS
  4768.  
  4769.  - While in the browse screens, some of the option windows, and in the SIMPLE  
  4770.    EDITOR, pressing the F1 key, will display a help screen.                    
  4771.                                                                                
  4772.  - BROWSE help:                                                                
  4773.                                                                                
  4774.  ┌──────────────────────[ DAYORPT HELP: DBEDIT, 0,  ]─────────────────────────┐
  4775.  │                                                                            │
  4776.  │- Special keys for 'moving around' the BROWSE screen are:                   │
  4777.  │                                                                            │
  4778.  │  Left Arrow Key      - Move to next field to your left                     │
  4779.  │  Right Arrow Key     - Move to next field to your right                    │
  4780.  │  Ctrl Home           - Go to the leftmost field                            │
  4781.  │  Ctrl End            - Go to the rightmost field (on the end of the record)│
  4782.  │  Up Arrow            - Move highlight to the previous record               │
  4783.  │  Down Arrow          - Move highlight to the next record                   │
  4784.  │  PgUp                - Page up a full screen of records                    │
  4785.  │  PgDn                - Page down a full screen of records                  │
  4786.  │  Ctrl PgUp           - Go to the beginning of the file                     │
  4787.  │  Ctrl PgDn           - Go to the end or last record of the file            │
  4788.  │  Ctrl N              - Add a record (where applicable)                     │
  4789.  │  Ctrl U              - Delete a record (where applicable)                  │
  4790.  │  F5,F6,F7            - To seek/find a record based upon the active index   │
  4791.  │  Esc                 - Exit the current operation                          │
  4792.  │                                                                            │
  4793.  │  Remember that there are many more fields to the right of the screen.      │
  4794.  │  Press the right arrow key to view them...                                 │
  4795.  └────────────────────────────────────────────────────────────────────────────┘
  4796.                                                                                
  4797.                                                                                
  4798.  - Option Box Help:                                                            
  4799.                                                                                
  4800.  ┌───────────────────────[ DAYORPT HELP: ACHOICE, 0,  ]───────────────────────┐
  4801.  │                                                                            │
  4802.  │                                                                            │
  4803.  │                                                                            │
  4804.  │                                                                            │
  4805.  │ - Special keys for 'moving around' the Option Box are:                     │
  4806.  │                                                                            │
  4807.  │   Up Arrow            - Move up one option                                 │
  4808.  │   Down Arrow          - Move down one option                               │
  4809.  │   PgUp                - Page up multiple records                           │
  4810.  │   PgDn                - Page down multiple records                         │
  4811.  │   Esc                 - ABORT and Exit                                     │
  4812.  │                                                                            │
  4813.  │                                                                            │
  4814.  │   After highlighting the option you desire, press Enter...                 │
  4815.  │                                                                            │
  4816.  │                                                                            │
  4817.  │                                                                            │
  4818.  └────────────────────────────────────────────────────────────────────────────┘
  4819.    DAYO Smart Reports,    TJS LAB                                    Page: 73
  4820.                                                                                
  4821.                                                                                
  4822.                                                                                
  4823.  - Editor help:                                                                
  4824.                                                                                
  4825.  ┌──────────────────────[ DAYORPT HELP: MEMOEDIT, 0,  ]───────────────────────┐
  4826.  │                                                                            │
  4827.  │ - Special keys for 'moving around' the EDITOR screen are:                  │
  4828.  │                                                                            │
  4829.  │   Left Arrow Key      - Move to your left                                  │
  4830.  │   Right Arrow Key     - Move to your right                                 │
  4831.  │   Ctrl Home           - Go to the top, leftmost corner of window           │
  4832.  │   Ctrl End            - Go to the bottom, rightmost corner of window       │
  4833.  │   Up Arrow            - Move up one line                                   │
  4834.  │   Down Arrow          - Move down one line                                 │
  4835.  │   PgUp                - Page up a full screen                              │
  4836.  │   PgDn                - Page down a full screen                            │
  4837.  │   Ctrl PgUp           - Go to the beginning of the file                    │
  4838.  │   Ctrl PgDn           - Go to the end of the file                          │
  4839.  │   Ctrl W              - SAVE Changes and Exit                              │
  4840.  │   Esc                 - ABORT Changes and Exit                             │
  4841.  │   F2                  - Import another text file into your document        │
  4842.  │                                                                            │
  4843.  │   The margin may exceed the boundaries on the right side of the screen,    │
  4844.  │   but the text is easily accessed using the special keys above...          │
  4845.  │                                                                            │
  4846.  │                                                                            │
  4847.  └────────────────────────────────────────────────────────────────────────────┘
  4848.  
  4849.  
  4850.  
  4851.  ■ EXPANDED HELP
  4852.  
  4853.       After Version 1.3, expanded help routines were added to all DAYO modules.
  4854.   At almost all prompts and menus you can press  F1  for help. Help can be a
  4855.   function key message as displayed on previous page, a message that you have
  4856.   created (user defined & inputted), or the ability to read the documentation
  4857.   on the screen (saves paper).
  4858.    DAYO Smart Reports,    TJS LAB                                    Page: 74
  4859.  
  4860.  
  4861.  
  4862.  ■ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES
  4863.  
  4864.       If you press F1 and no user defined & inputted message exists for that
  4865.   section of the program you are currently in you will receive a message to
  4866.   this effect, and then a blank/empty screen.
  4867.  
  4868.       The editing keys for this option are the same as for the Simple Editor
  4869.   (previous page).
  4870.  
  4871.  
  4872.   DAYOPAY V2.0, TJS LAB                                 ┌────[August 1990]───┐
  4873.  ┌──────[ DAYO HELP    Called by Program: DAYOPAY      Variable: OPT ]───────┐
  4874.  │                                                                           │
  4875.  │                                                                           │
  4876.  │                                                                           │
  4877.  │                                                                           │
  4878.  │                                                                           │
  4879.  │                                                                           │
  4880.  │         ╔════════════════════════════════════════════════════════╗        │
  4881.  │         ║    No Online Help Messages Exist for this prompt...    ║        │
  4882.  │         ║                                                        ║        │
  4883.  │         ║    You can type in any help message you wish, or       ║        │
  4884.  │         ║    press  F1  to view the document for DAYOPAY.        ║        │
  4885.  │         ║                                                        ║        │
  4886.  │         ║                                                        ║        │
  4887.  │         ║              Press any key to continue...              ║        │
  4888.  │         ╚════════════════════════════════════════════════════════╝        │
  4889.  │                                                                           │
  4890.  │                                                                           │
  4891.  ├───────────────────────────────────────────────────────────────────────────┤
  4892.  │  Esc  (Exit)   Ctrl W (Save Changes)   F1 (Read Manual)                   │
  4893.  └───────────────────────────────────────────────────────────────────────────┘
  4894.  
  4895.  
  4896.        If you wish to input anything at this point, just type whatever you
  4897.   wish, remembering to press  Ctrl W  to save all changes. Pressing  Esc  will
  4898.   not save ANY changes ( all effort you put into writing a help message will
  4899.   be lost! ).
  4900.    DAYO Smart Reports,    TJS LAB                                    Page: 75
  4901.  
  4902.  
  4903.  
  4904.   DAYOPAY V2.0, TJS LAB                                   ┌────[August 1990]──┐
  4905.  ┌───────[ DAYO HELP    Called by Program: DAYOPAY      Variable: OPT ]───────┐
  4906.  │                                                                            │
  4907.  │                                                                            │
  4908.  │                                                                            │
  4909.  │                                                                            │
  4910.  │  Type in anything you wish about this portion of the program!              │
  4911.  │                                                                            │
  4912.  │  The length of this file can be many pages...                              │
  4913.  │                                                                            │
  4914.  │  Be sure to press  Ctrl W  to save any changes/additions you make to this  │
  4915.  │  screen.                                                                   │
  4916.  │                                                                            │
  4917.  │                                                                            │
  4918.  │                                                                            │
  4919.  │                                                                            │
  4920.  │                                                                            │
  4921.  │                                                                            │
  4922.  ├────────────────────────────────────────────────────────────────────────────┤
  4923.  │   Esc  (Exit)   Ctrl W (Save Changes)   F1 (Read Manual)         13/4      │
  4924.  └────────────────────────────────────────────────────────────────────────────┘
  4925.  
  4926.  
  4927.  
  4928.  ■ VIEW DOCUMENTATION ONSCREEN
  4929.  
  4930.       To view the documentation for the module you are in, it must first exist
  4931.   in the current directory. Document files are named the same as the module,
  4932.   and have the extension of '.DOC', ie: DAYOINV.DOC, DAYOPOS.DOC, DAYOPAY.DOC.
  4933.   Press  F1  in the User Defined & Inputted Help Message screen to display the
  4934.   document (user manual). The special keys in this option are displayed in the
  4935.   Help Screen (press F1 again) for this option:
  4936.  
  4937.  
  4938.   ╔══════════════════════════════════════════════════════════════════════════╗  
  4939.   ║  While viewing the document for DAYOPAY the keyboard is configured       ║  
  4940.   ║  as followed:                                                            ║  
  4941.   ║                                                                          ║
  4942.   ║        Esc        Exit                                                   ║  
  4943.   ║        F5         Find a string. This search is not case sensitive       ║  
  4944.   ║                   Examples:     PAGE: 50                                 ║  
  4945.   ║                                 INTRODUCTION                             ║  
  4946.   ║                                 REPORTS                                  ║  
  4947.   ║        Home       Return to the beginning of the document                ║  
  4948.   ║        End        Go to the bottom of the document                       ║  
  4949.   ║        PgUp       Page up                                                ║  
  4950.   ║                                                                          ║  
  4951.   ║        Any other key moves acts like PgDn (page down)                    ║  
  4952.   ║                                                                          ║  
  4953.   ║                       Press any key to continue...                       ║
  4954.   ╚══════════════════════════════════════════════════════════════════════════╝
  4955.    DAYO Smart Reports,    TJS LAB                                    Page: 76
  4956.  
  4957.                                                                                
  4958.                                                                                
  4959.  ■ DAYO SMART REPORTS MAINTENANCE & QUIRKS
  4960.  
  4961.  
  4962.  - If you are on a multiuser network, you must 'flag' (change file attributes) 
  4963.    of all files to make them sharable, readable and writable. Note that the    
  4964.    command/program 'flag' may be called by a different name on your network.   
  4965.                                                                                
  4966.                                                                                
  4967.    ie:                                                                         
  4968.                                                                                
  4969.    E:\>FLAG  *.NTX SRW                                                         
  4970.                                                                                
  4971.    or just to be safe, go ahead and flag all files in the DAYO directory:      
  4972.                                                                                
  4973.    E:\>FLAG  *.* SRW                                                           
  4974.                                                                                
  4975.                                                                                
  4976.  - Backups of your data and configuration files should take place daily! You   
  4977.    have no doubt heard many 'scare' stories about losing data. They are all    
  4978.    true! The key files that need to be backed up all have the extension of     
  4979.    .DBF, .DBT, and .CFG. The .DBF files are your databases. The .DBT files     
  4980.    are notes/memos. The .CFG file(s) contain your configuration information    
  4981.    (as seen in the Configuration module).                                      
  4982.                                                                                
  4983.  - If you are on a network, it is NOT recommended that you use dBase III+ with 
  4984.    the databases. It may write an end of file marker not always recognized by  
  4985.    DAYO. Appending additional records to the database after this point often   
  4986.    leads/creates a 'bad record' in the database.                               
  4987.                                                                                
  4988.  - If you must use dBase (tm) with DAYO Smart Reports, and you are on a PC based
  4989.    network/LAN, be sure to SET EXCLUSIVE OFF before you open ANY databases.    
  4990.    This will allow the opened databases to be shared, and more importantly,    
  4991.    prevent a user (or all users!) from 'crashing'!                             
  4992.                                                                                
  4993.  - If the SIMPLE EDITOR tends to 'hang' your CPU, even on small files, then    
  4994.    do not use it... Hope to fix this 'feature' with the next upgrade...        
  4995.    DAYO Smart Reports,    TJS LAB                                    Page: 77
  4996.  
  4997.  
  4998.  
  4999.  ■ TJS 'Computer' LAB
  5000.  
  5001.  
  5002.    TJS LAB produces customized, multiuser software for the PC based network
  5003.    (ie: Novell and others). Our specialties include Inventory Control, PC
  5004.    Communications/EDI, Management, Reports (standard and graphic), Data
  5005.    Conversions, and Accounting (ie: A/R, A/P, G/L).
  5006.  
  5007.    A unique feature of TJS LAB is that our software is by default, multiuser.
  5008.    'Standalone' applications are the exception! All our applications are
  5009.    written in Clipper, Basic, or C (preferably Basic or Clipper). We will
  5010.    license all our application source codes. We produce applications that work,
  5011.    are easy to use, and are very reasonably priced!
  5012.  
  5013.    Custom/contract programming is available. We make program enhancements and
  5014.    changes very quickly; usually within 24 hours!
  5015.  
  5016.    Want a change?
  5017.    Want an enhancement!
  5018.    Want a completely new product/application?
  5019.    Want to make your idea a reality?
  5020.    Call us for a quote or just for more information!
  5021.  
  5022.  
  5023.    Write us at:
  5024.  
  5025.        TJS LAB
  5026.        PO Box 585366
  5027.        Orlando, Florida 32858
  5028.  
  5029.    Or call us, 08:00am to 11:00pm Mon-Sat
  5030.    Voice Mail between 11:00pm to 08:00am:     (407) 291-3960/6987
  5031.  
  5032.    ┌──────────────────────────────────────────────────────────────────────┐
  5033.    │ Note that TJS LAB will not accept/take any support calls for         │
  5034.    │      UNregistered products!                                          │
  5035.    └──────────────────────────────────────────────────────────────────────┘
  5036.  
  5037.